Our application are running on Oracle 9.2.0.5.0 on Unix 11.11. we would like to get touch with our customers by sending message to their mobile phones. we would like to do this from the database side. how can we achinve this?

There are two solutions
1) Some service providers will recognise emails and interpret them as sms and send it to the appropriate person. you can try sending it as phone number@serviceprovider.com (e.g. 9825666@att.com).

2) You can try webservices. e.g. goto wehservicex.net. there are free webservices for sending sms. You create a webservice stub, then create a java class for that . You can write a plsql wrapper package. This you can call from your application

Thanks

Tom,
I hope that you will fine. Tom, Here I am sending My Suggestion & Experience to Send SMS From Oracle to Mobile Device.

There is a Way to send Message From Oracle Database Server to Mobile Device.

One Way is to Send Email using Oracle SMTP Package - [UTL_SMTP].
----------------------------------------------------------------
Mostly Cellular Service Providers give the Facility to their Post-Paid Users to Recieve Email on Post-Paid Connections.{Mobile_No@Service_Provider_Domain.com} is the E-Mail Address for Post-Paid Connection Holder.
e.g. +923003338669@mobilinkgsm.com.

In this Way, Install/Configure Oracle Database 8.x/9.x/10.x and Create a Package.
</code> http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/maildemo_sql.txt

BEGIN 
     demo_mail.mail(
                    sender => 'Me <me@some-company.com>',
                    recipients => 'Someone <Mobile_No@Celluler_Service_Provider_Domain.com>' ,                       subject    => 'SMS From Oracle Database Server',                       
                    message => 'Hi! This is a test Message.'
                    );
END;
/

Second Way is to Send SMS Using GSM Modem/Mobile Phone & its Supporting Software/Utility:
-----------------------------------------------------------------------------------------

There are many software/utilities/Tools which can do this, but here i am using a free project.
In this Way, Install/Configure:

* Red Hat Linux Operating System
* Oracle Database 8i/9.x/10.x
* Gnokii - For Nokia Mobile Phone
                       
To Download Gnokii:

http://gnokii.org/download/gnokii/0.6.x/gnokii-0.6.2.tar.gz

To Install Gnokii:

http://urtica.linuxnews.pl/~pkot/gnokii/gnokii.html#ch1

Gnokii Sample File:

http://cvs.savannah.nongnu.org/viewcvs/gnokii/gnokii/Docs/sample/gnokiirc?rev=1.22

Gnokii User Guide:

http://wiki.gnokii.org/index.php/User%27s_Guide

              
* Nokia Mobile Phone With Data Cable

http://www.gnokii.org/cables.shtml

Try to Send SMS Using the Command.

Waseem$ echo "This is a test SMS using Gnokii-Linux..." | gnokii --sendsms +923003338669

Note : Message Length = 160 Characters.

It Will Take 30 - 40 Seconds and will send the SMS to the desired Number.

To Test & Configure it in Oracle Database, you have to Create a Java Class.

http://www.oracle-base.com/articles/8i/ShellCommandsFromPLSQL.php <code>


SET SERVEROUTPUT ON SIZE 1000000
CALL DBMS_JAVA.SET_OUTPUT(1000000);
BEGIN
Host_Command (p_command => 'echo "This is a test SMS from Oracle Database." | gnokii --sendsms +923003338669');
END;
/


I have tried it on Nokia 6030 and its Working.


Best Regards
Muhammad Waseem Haroon
waseemharoon@gmail.com
mwaseem_haroon@yahoo.com
ocp_waseem@hotmail.com

Hi, I tried gnooki and it works from dos promt, but I'm unable to send sms or dial a test phone number from oracle.
I receive the message "Procedure successfully completed" but nothing happens.
Thank you.
Bye, Leo

This for example:
This for example:

SET SERVEROUTPUT ON SIZE 1000000
CALL DBMS_JAVA.SET_OUTPUT(1000000);
BEGIN
Host_Command (p_command => 'echo "This is a test SMS from Oracle Database." |
gnokii --sendsms +923003338669');
END;
/

Ok, thank you anyway.
I'm not very expert, sorry.
I'm trying to send sms through the databse.
Initially I enableb the database jvm.
then I loaded the comm api from sun plus a small java application which lists com ports.
calling the application from the command prompt I see the com port list on my pc, but nothing if I call the function from sqlplus. Everything seems to be ok, but no port are listed.
any idea?
thank you.

Hi Tom

I don't have any knowledge about java.
I have an assignment to write code to send sms to customers about their balance in oracle pl/sql.
Is there any inbuilt package to do that.

Please, Tom I have to create a job which will be sending an SMS upon a trigger from a DML on particular tables. Please, could I have any description of this from you?
Thanks

You can read the same below.

http://www.oracletechnical.com/post/2016/08/15/how-to-send-sms-from-oracle-to-any-mobile-number