Hello All!
There is a Way to send Message From Oracle Database Server to Mobile Device.
<font color="navy"><b>One Way is to Send Email using Oracle SMTP Package - [UTL_SMTP].</b></font id="navy">
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.
http://www.oracle.com/technology/sample ... mo_sql.txt
<pre id='pre'><font size=2>
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;
</font></pre id='pre'>
<font color="navy"><b>Second Way is to Send SMS Using GSM Modem/Mobile Phone & its Supporting Software/Utility.</b></font id="navy">
There are many software/utilities/Tools which can do this, but here i am using a free project.
In this Way, Install/Configure:
<pre id='pre'><font size=2>
* Red Hat Linux Operating System
* Oracle Database 8i/9.x/10.x
* Gnokii - For Nokia Mobile Phone
Download : http://gnokii.org/download/gnokii/0.6.x ... 6.2.tar.gz
Install : http://urtica.linuxnews.pl/~pkot/gnokii/gnokii.html#ch1
Sample File : http://cvs.savannah.nongnu.org/viewcvs/ ... c?rev=1.22
User Guide : http://wiki.gnokii.org/index.php/User%27s_Guide
* Nokia Mobile Phone With Data Cable - http://www.gnokii.org/cables.shtml
</font></pre id='pre'>
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/ ... mPLSQL.php
<pre id='pre'><font size=2>
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;
/
</font></pre id='pre'>
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
Send Message From Oracle To Mobile Device
Who is online
Users browsing this forum: No registered users and 8 guests