FUNCTION SEND_QUERY(a_url       varchar2,
                      a_proc_name varchar2,
                      a_xml       clob,
                      a_log_id    number default null) RETURN clob AS
 
    l_blob blob := convert_to_blob(a_xml, 'AL32UTF8');
 
    l_http_request  UTL_HTTP.req;
    l_http_response UTL_HTTP.resp;
 
    l_varchar2_response varchar2(32767);
    l_buff              raw(32767);
 
    --    l_return          xmltype;
    l_dpd_xml_log_id number;
 
    l_cnt    number;
    l_offset number;
 
  BEGIN
    if a_log_id is null then
      l_dpd_xml_log_id := spsr_xml_log_seq.nextval;
    else
      l_dpd_xml_log_id := a_log_id;
    end if;
 
    xml_loger(l_dpd_xml_log_id, a_proc_name, xmltype(a_xml));
 
    --формируем HTTP запрос
    l_http_request := UTL_HTTP.begin_request(a_url, 'POST', 'HTTP/1.1');
    --проставим заголовки
    UTL_HTTP.set_header(l_http_request, 'Content-Type', 'text/xml');
    UTL_HTTP.set_header(l_http_request,
                        'Content-Length',
                        dbms_lob.getlength(l_blob));
    --тут циклом читаем clob который надо передать и кусками передаем через HTTP соединение
    l_cnt    := 32767;
    l_offset := 1;
    loop
      dbms_lob.read(l_blob, l_cnt, l_offset, l_buff);
      UTL_HTTP.write_raw(l_http_request, l_buff);
      l_offset := l_offset + l_cnt;
      exit when l_cnt < 32767;
    end loop;
    --получаем HTTP ответ
    l_http_response := UTL_HTTP.get_response(l_http_request);
 
    UTL_HTTP.read_text(l_http_response, l_varchar2_response);
 
    --    dbms_output.put_line(l_varchar2_response);
 
    UTL_HTTP.end_response(l_http_response);
 
    xml_loger(l_dpd_xml_log_id,
              a_proc_name,
              XMLTYPE.createxml(l_varchar2_response));
 
    RETURN l_varchar2_response;
  END;

ICBGVU5DVElPTiBTRU5EX1FVRVJZKGFfdXJsICAgICAgIHZhcmNoYXIyLAogICAgICAgICAgICAgICAgICAgICAgYV9wcm9jX25hbWUgdmFyY2hhcjIsCiAgICAgICAgICAgICAgICAgICAgICBhX3htbCAgICAgICBjbG9iLAogICAgICAgICAgICAgICAgICAgICAgYV9sb2dfaWQgICAgbnVtYmVyIGRlZmF1bHQgbnVsbCkgUkVUVVJOIGNsb2IgQVMKICAKICAgIGxfYmxvYiBibG9iIDo9IGNvbnZlcnRfdG9fYmxvYihhX3htbCwgJ0FMMzJVVEY4Jyk7CiAgCiAgICBsX2h0dHBfcmVxdWVzdCAgVVRMX0hUVFAucmVxOwogICAgbF9odHRwX3Jlc3BvbnNlIFVUTF9IVFRQLnJlc3A7CiAgCiAgICBsX3ZhcmNoYXIyX3Jlc3BvbnNlIHZhcmNoYXIyKDMyNzY3KTsKICAgIGxfYnVmZiAgICAgICAgICAgICAgcmF3KDMyNzY3KTsKICAKICAgIC0tICAgIGxfcmV0dXJuICAgICAgICAgIHhtbHR5cGU7CiAgICBsX2RwZF94bWxfbG9nX2lkIG51bWJlcjsKICAKICAgIGxfY250ICAgIG51bWJlcjsKICAgIGxfb2Zmc2V0IG51bWJlcjsKICAKICBCRUdJTgogICAgaWYgYV9sb2dfaWQgaXMgbnVsbCB0aGVuCiAgICAgIGxfZHBkX3htbF9sb2dfaWQgOj0gc3Bzcl94bWxfbG9nX3NlcS5uZXh0dmFsOwogICAgZWxzZQogICAgICBsX2RwZF94bWxfbG9nX2lkIDo9IGFfbG9nX2lkOwogICAgZW5kIGlmOwogIAogICAgeG1sX2xvZ2VyKGxfZHBkX3htbF9sb2dfaWQsIGFfcHJvY19uYW1lLCB4bWx0eXBlKGFfeG1sKSk7CiAgCiAgICAtLdGE0L7RgNC80LjRgNGD0LXQvCBIVFRQINC30LDQv9GA0L7RgQogICAgbF9odHRwX3JlcXVlc3QgOj0gVVRMX0hUVFAuYmVnaW5fcmVxdWVzdChhX3VybCwgJ1BPU1QnLCAnSFRUUC8xLjEnKTsKICAgIC0t0L/RgNC+0YHRgtCw0LLQuNC8INC30LDQs9C+0LvQvtCy0LrQuAogICAgVVRMX0hUVFAuc2V0X2hlYWRlcihsX2h0dHBfcmVxdWVzdCwgJ0NvbnRlbnQtVHlwZScsICd0ZXh0L3htbCcpOwogICAgVVRMX0hUVFAuc2V0X2hlYWRlcihsX2h0dHBfcmVxdWVzdCwKICAgICAgICAgICAgICAgICAgICAgICAgJ0NvbnRlbnQtTGVuZ3RoJywKICAgICAgICAgICAgICAgICAgICAgICAgZGJtc19sb2IuZ2V0bGVuZ3RoKGxfYmxvYikpOwogICAgLS3RgtGD0YIg0YbQuNC60LvQvtC8INGH0LjRgtCw0LXQvCBjbG9iINC60L7RgtC+0YDRi9C5INC90LDQtNC+INC/0LXRgNC10LTQsNGC0Ywg0Lgg0LrRg9GB0LrQsNC80Lgg0L/QtdGA0LXQtNCw0LXQvCDRh9C10YDQtdC3IEhUVFAg0YHQvtC10LTQuNC90LXQvdC40LUKICAgIGxfY250ICAgIDo9IDMyNzY3OwogICAgbF9vZmZzZXQgOj0gMTsKICAgIGxvb3AKICAgICAgZGJtc19sb2IucmVhZChsX2Jsb2IsIGxfY250LCBsX29mZnNldCwgbF9idWZmKTsKICAgICAgVVRMX0hUVFAud3JpdGVfcmF3KGxfaHR0cF9yZXF1ZXN0LCBsX2J1ZmYpOwogICAgICBsX29mZnNldCA6PSBsX29mZnNldCArIGxfY250OwogICAgICBleGl0IHdoZW4gbF9jbnQgPCAzMjc2NzsKICAgIGVuZCBsb29wOwogICAgLS3Qv9C+0LvRg9GH0LDQtdC8IEhUVFAg0L7RgtCy0LXRggogICAgbF9odHRwX3Jlc3BvbnNlIDo9IFVUTF9IVFRQLmdldF9yZXNwb25zZShsX2h0dHBfcmVxdWVzdCk7CiAgCiAgICBVVExfSFRUUC5yZWFkX3RleHQobF9odHRwX3Jlc3BvbnNlLCBsX3ZhcmNoYXIyX3Jlc3BvbnNlKTsKICAKICAgIC0tICAgIGRibXNfb3V0cHV0LnB1dF9saW5lKGxfdmFyY2hhcjJfcmVzcG9uc2UpOwogIAogICAgVVRMX0hUVFAuZW5kX3Jlc3BvbnNlKGxfaHR0cF9yZXNwb25zZSk7CiAgCiAgICB4bWxfbG9nZXIobF9kcGRfeG1sX2xvZ19pZCwKICAgICAgICAgICAgICBhX3Byb2NfbmFtZSwKICAgICAgICAgICAgICBYTUxUWVBFLmNyZWF0ZXhtbChsX3ZhcmNoYXIyX3Jlc3BvbnNlKSk7CiAgCiAgICBSRVRVUk4gbF92YXJjaGFyMl9yZXNwb25zZTsKICBFTkQ7