5 Replies Latest reply on Aug 27, 2012 9:54 AM by usman_noshahi

    forms: connect mobile phone to send SMS

      Hi Gurus ,

      I am using
              Oracle Database 10g Enterprise Edition Release - Prod
      PL/SQL Release - Production
      CORE      Production
      TNS for 32-bit Windows: Version - Production
      NLSRTL Version - Production
      and oracle forms 10g 10.1.2

      I wanna connect my mobile lets say (nokia , glaxy , qmobile) to forms and on any trigger like button pressed, send messages to selected cell numbers from the database..

      is it possible ?

      usman noshahi
        • 1. Re: forms: connect mobile phone to send SMS
          Yes it's possible..

          1. you can send sms over webservice (if your provider has this option)

          2. you can send sms over RS232 port to your phone ...

          3. you can use a modem to send sms (http://www.dailymotion.com/video/xl84uz_how-to-send-sms-with-wavecom-fastrack-modem-using-rs232-cable_tech)

          in oracle forms you can write a java pjc with rxtx library.....
          I think you can also write a java stored procedure to send datas over rs232 port....

          Do you have some hardware to send sms? Tell us more....
          • 2. Re: forms: connect mobile phone to send SMS
            Look at this..


            Also you can send sms over rs232 with at commands...

            In my country we have a provider to send sms messages over webservice
            • 3. Re: forms: connect mobile phone to send SMS
              thanks for your replies...

              I know about OZEKI , but here the matter is different.
              I have mobile fon QMOBILE E950. While connecting to the com port I can send messages to contact number using
              it's own PC-SUIT(software) or using AT command

              like this: please have a look at this link.


              I tried these commands , and my mobile is supported with these commands. I just wanna make a bulk sms system which sends sms on multiple numbers and these numbers should be fetched from database....

              Sorry don't know much about java strord procedures how to write and use then on oracle forms..

              • 4. Re: forms: connect mobile phone to send SMS
                If you like to send sms from your client (forms based application) you must do a PJC (plugable java component).. For sending and receiving datas from RS232 you can use a RXTX library (http://rxtx.qbang.org/wiki/index.php/Main_Page).

                If you like to send sms directly from your remote database (I think) you can import apropriate rxtx jar library into your database and write down a java stored procedure..

                Third way you can implement a java Class which sends sms and expose it as webservice on your remote server.. From plsql is easy to communicate with webservice and so you can also send sms..

                I have done a java bean for Hypercom POS terminal which is connected over RS232 with forms application (using rxtx library)..

                Edited by: peterv6i.blogspot.com on May 8, 2012 8:11 AM
                • 5. Re: forms: connect mobile phone to send SMS
                  hi peterv6i.....,

                  I am really sorry sir I was busy in my exams so couldn't work on my assignment that's why can't complete this...
                  I wanna use this way as you posted

                  +. you can use a modem to send sms (http://www.dailymotion.com/video/xl84uz_how-to-send-sms-with-wavecom-fastrack-modem-using-rs232-cable_tech)+

                  I have this device and sim card too , but I am confused about Ozeki gateway because I think I have to pay for using this services in my country..

                  more over if it's possible to send SMS from oracle forms using PJC or any java class without paying any extra charges then I don't have much knowledge about applying java and java classes , stored programs of jave on oracle forms , please guide me more ...