0 Replies Latest reply: Dec 11, 2012 7:45 AM by Joe007 RSS

    UTL_HTTP for web service to send an SMS

    Joe007
      Hi All,

      I am trying to send SMS through a web service, and before doing it on a form, I tried to check this with UTL_HTTP from sql plus

      below given is the code i tried

      SQL> SET DEFINE OFF
      SQL> SELECT UTL_HTTP.REQUEST('http://80.227.146.106/Receiver/sms99.aspx?usr=JOE123&pass=JOE321&
      msisdn=971556221690&msg=test msg through ibuzz&mt=0') FROM DUAL;

      and am getting the result as shown below

      UTL_HTTP.REQUEST('HTTP://80.227.146.106/RECEIVER/SMS99.ASPX?USR=JOE123&PASS=JOE321&MSISDN=97155
      <HTML><HEAD>
      <TITLE>Request Error</TITLE>
      </HEAD>
      <BODY>
      <big></big>
      <TABLE border=0 cellPadding=1 width="80%">
      <TR><TD>
      <big>Request Error (unsupported_protocol)</big>


      </TD></TR>
      <TR><TD>
      Your request used a protocol that is not currently supported.
      </TD></TR>

      UTL_HTTP.REQUEST('HTTP://80.227.146.106/RECEIVER/SMS99.ASPX?USR=JOE123&PASS=JOE321&MSISDN=97155
      <TR><TD>

      </TD></TR>
      <TR><TD>


      </TD></TR>
      </TABLE>
      </BODY></HTML>

      **********-----------------------------------------------------------------------------------------------------------------------------------------------------------********
      protocol used for the webservice is HTTP
      they have given an IP with port number
      and the method is GET
      url 'http://80.227.146.106/Receiver/sms99.aspx'
      parameters are msisdn, msg, mt
      their response would be either true or false.

      I tried this on Oracle9i Enterprise Edition Release 9.2.0.1.0
      and the message is
      Your request used a protocol that is not currently supported.

      when i tried the same on Oracle Database 11g Release 11.2.0.1.0
      i got
      Request Error (unsupported_protocol)

      Can someone help please...........