I think you'll need to read up on the concepts of SMS protocols and gateways to figure out how to get started. There are built-in packages in Oracle 10g and 11g (such as UTL_HTTP) which allows you to communicate via web protocols and even to consume SOA web services. Perhaps if you set up a webserver which can send messages based on calls to a web api or a web form, you can leverage such a package.
If you're looking for something like "DBMS_SMS" or some other convenient PL/SQL code that will directly allow SMS messaging, I am highly doubtful that it exists except in custom implementations where the programmers have taken the time to figure out how to interface their messaging servers with their database servers. You may not be able to leverage the SMS app purely with PL/SQL. It may require a hand off to some other code written for the purpose of SMS messaging. Therein lies the challenge. Hope that helps. Rich Pascual On Mon, Nov 29, 2010 at 7:28 PM, rajshekhar gadepalli <grajshek...@gmail.com > wrote: > Hi All, > > > From many a days, i am looking for logic , to send SMS to mobile phones > using PLSQL. Can anyone help me with this ? > > Thanks in advance !! > > -- > Best Regards, > Rajshekhar > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en