1. ОТПРАВКА SMS-СООБЩЕНИЙ.
Для отправки сообщений через систему smspro.nikita.kg оборудование партнера должно
вызвать скрипт: http://smspro.nikita.kg/api/message
Либо https://smspro.nikita.kg/api/message для работы по защищенному SSL-протоколу
Для вызова используется POST – запрос.
Тело запроса должно содержать XML документ вида:
<?xml version="1.0" encoding="UTF-8"?>
<message>
<login>login</login>
<pwd>passwd</pwd>
<id>A88726</id>
<sender>My-company</sender>
<text>Any SMS message text</text>
<time>20100921235957</time>
<phones>
<phone>996550123456</phone>
<phone>996550123457</phone>
</phones>
<test>1</test>
</message>

create or replace procedure send_sms_nikita is
  req utl_http.req;
  res utl_http.resp;
  url varchar2(4000) := 'http://smspro.nikita.kg/api/message';
  --name varchar2(4000);
  buffer varchar2(4000);
  content varchar2(4000) := '<?xml version="1.0" encoding="UTF-8"?>
<message>
<login>nikita</login>
<pwd>qwerty</pwd>
<id>999999</id>
<sender>OAO SAD</sender>
<text>Any SMS message text</text>
<phones>
<phone>996550665577</phone>
</phones>
</message>';

begin
  req := utl_http.begin_request(url, 'POST',' HTTP/1.1');
  utl_http.set_header(req, 'user-agent', 'mozilla/4.0');
  utl_http.set_header(req, 'content-type', 'application/xml');
  utl_http.set_header(req, 'Content-Length', length(content));

  utl_http.write_text(req, content);
  res := utl_http.get_response(req);
  -- process the response from the HTTP call
  begin
    loop
      utl_http.read_line(res, buffer);
      dbms_output.put_line(buffer);
    end loop;
    utl_http.end_response(res);
  exception
    when utl_http.end_of_body
    then
      utl_http.end_response(res);
  end;
end;

CREATE OR REPLACE FUNCTION add_numbers (p_int_1  IN  NUMBER,
                                        p_int_2  IN  NUMBER)
  RETURN NUMBER
AS
  l_envelope  CLOB;
  l_xml       XMLTYPE;
  l_result    VARCHAR2(32767);
BEGIN

  -- Build a SOAP document appropriate for the web service.
  l_envelope := '<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <soap:Body>
    <ws_add xmlns="http://oracle-base.com/webservices/" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
      <int1 xsi:type="xsd:integer">' || p_int_1 || '</int1>
      <int2 xsi:type="xsd:integer">' || p_int_2 || '</int2>
    </ws_add>
  </soap:Body>
</soap:Envelope>';

  -- Get the XML response from the web service.
  l_xml := APEX_WEB_SERVICE.make_request(
    p_url      => 'http://oracle-base.com/webservices/server.php',
    p_action   => 'http://oracle-base.com/webservices/server.php/ws_add',
    p_envelope => l_envelope
  );

  -- Display the whole SOAP document returned.
  DBMS_OUTPUT.put_line('l_xml=' || l_xml.getClobVal());

  -- Pull out the specific value of interest.
  l_result := APEX_WEB_SERVICE.parse_xml(
    p_xml   => l_xml,
    p_xpath => '//return/text()',
    p_ns    => 'xmlns:ns1="http://oracle-base.com/webservices/"'
  );

  DBMS_OUTPUT.put_line('l_result=' || l_result);

  RETURN TO_NUMBER(l_result);
END;

 http://smspro.nikita.kg/api/messag