How to Send SMS from Oracle Database using NowSMS | Search |
NowSMS Support Forums ⬆ MMS & SMS Technical Discussions (unsupported) ⬆ |
◄ ► |
Author | Message | |||
Muhammad Nadeem New member Username: Nadeem14375gmailcom Post Number: 1 Registered: 06-2014 |
hi, I have an application developed with oracle forms and using oracle database 10g. Can I integrate nowsms and how? Regards Muhammad Nadeem http://star-business-directory.com/ | |||
Des - NowSMS Support Board Administrator Username: Desosms Post Number: 4928 Registered: 08-2008 |
Hi, I don't have any tested examples, but basically you just need to be able to issue an HTTP request from the Oracle side. You send an HTTP request from the Oracle form application to the NowSMS server. So, on the Oracle side, you need to create a function or procedure that tells NowSMS to send a message. The following link explains the HTTP URL format for sending a text message via NowSMS: http://www.nowsms.com/doc/submitting-sms-messages/sending-sms-text-messages I have no experience working with Oracle, so I did a web search to find a good example of making an HTTP request from an Oracle form. I liked the example at http://www.inside-oracle-apex.com/sending-sms-to-mobile-phone/, so I modified that code to create an example procedure to send an SMS from an Oracle database form. (This example uses HTTP POST instead of HTTP GET, but NowSMS will work with either format.) Before attempting to use the example, note the following: 1.) Make sure you can send an SMS from the NowSMS web interface before attempting to use this procedure. 2.) Create an "SMS User" account in NowSMS that will be used by the procedure. 3.) Modify the following lines in the procedure with values appropriate for your NowSMS installation:
4.) To send an SMS, call the example procedure with
Here is the example procedure, sendSMS:
As I said, I have no experience with Oracle development, so there may be errors. If this works, or if you find a solution that works, please share the results. -- Des NowSMS Support |