Home » SQL & PL/SQL » SQL & PL/SQL » send sms
send sms [message #318141] Mon, 05 May 2008 20:50 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
hi all
i use database 10.
i send sms by connecting to gateway via HTTP.
i write URL in my browser
Quote:
http://api.clickatell.com/http/sendmsg?user=xxxxx&password=xxxxx&api_id=xxxxx&to=448311234567&text=Meet+me+at+home

and it return message id.

i create code by c# to send sms via http
            WebClient client = new WebClient ();
            // Add a user agent header in case the requested URI contains a query.
            client.Headers.Add ("ree", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR1.0.3705;)");
            client.QueryString.Add("user", "xxxx");
            client.QueryString.Add("password", "xxxxx");
            client.QueryString.Add("api_id", "xxxxx");
            client.QueryString.Add("to", "+20102013707");
            client.QueryString.Add("text", "This is an example message");
            string baseurl ="http://api.clickatell.com/http/sendmsg";
            Stream data = client.OpenRead(baseurl);
            StreamReader reader = new StreamReader (data);
            string s = reader.ReadToEnd ();
            data.Close ();
            reader.Close ();
            MessageBox.Show(s);


how can i create function send sms via http by pl/sql?
Thax
Rafeek

[Updated on: Mon, 05 May 2008 20:52]

Report message to a moderator

Re: send sms [message #318142 is a reply to message #318141] Mon, 05 May 2008 20:56 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how can i create function send sms via http by pl/sql?
UTL_HTTP
Previous Topic: I need help in writing a stored procedure (Merged 4)
Next Topic: Reg tablespaces
Goto Forum:
  


Current Time: Thu Feb 13 09:47:16 CST 2025