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

UTL_HTTP package for sending 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>
<FONT face="Helvetica">
<big><strong></strong></big><BR>
</FONT>
<blockquote>
<TABLE border=0 cellPadding=1 width="80%">
<TR><TD>
<FONT face="Helvetica">
<big>Request Error (unsupported_protocol)</big>
<BR>
<BR>
</FONT>
</TD></TR>
<TR><TD>
<FONT face="Helvetica">
Your request used a protocol that is not currently supported.
</FONT>
</TD></TR>

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

</FONT>
</TD></TR>
<TR><TD>
<FONT face="Helvetica" SIZE=2>
<BR>

</FONT>
</TD></TR>
</TABLE>
</blockquote>
</FONT>
</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...........

Edited by: Joe on Dec 11, 2012 1:03 PM

Edited by: Joe on Dec 11, 2012 1:03 PM

Legend

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