This discussion is archived
0 Replies Latest reply: Dec 11, 2012 5:45 AM by joe007 RSS

UTL_HTTP for web service to send an SMS

joe007 Newbie
Currently Being Moderated
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...........

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points