Home » SQL & PL/SQL » SQL & PL/SQL » Send Message From Oracle To Mobile Device
Send Message From Oracle To Mobile Device [message #167156] Tue, 11 April 2006 10:03 Go to next message
Messages: 4
Registered: April 2006
Location: Karachi
Karma: 0
Junior Member

Hello All!

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 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.


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.');

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
Download  : http://gnokii.org/download/gnokii/0.6.x/gnokii-0.6.2.tar.gz
Install   : http://urtica.linuxnews.pl/~pkot/gnokii/gnokii.html#ch1          SampleFile: http://cvs.savannah.nongnu.org/viewcvs/gnokii/gnokii/Docs/sample/gnokiirc?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

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.

Host_Command (p_command => 'echo "This is a test SMS from Oracle Database." | gnokii --sendsms +923003338669');

I have tried it on Nokia 6030 and its Working.

Best Regards
Muhammad Waseem Haroon
  • Attachment: SendSMS.txt
    (Size: 2.81KB, Downloaded 954 times)
Re: Send Message From Oracle To Mobile Device [message #394612 is a reply to message #167156] Sat, 28 March 2009 10:58 Go to previous messageGo to next message
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Karma: 0
Senior Member

Thanks, i download the gnokii

but i am unable to use it

i have nokia 7710 mobile

can i know the configurations for gnokii file
database version is oracle 8.1.7

thanking you in anticipation.
Re: Send Message From Oracle To Mobile Device [message #394618 is a reply to message #394612] Sat, 28 March 2009 11:39 Go to previous message
Messages: 7880
Registered: March 2000
Karma: 0
Senior Member
Sorry, but this is not the least Oracle-related.

[Updated on: Sat, 28 March 2009 11:40]

Report message to a moderator

Previous Topic: Empty tables - where have my inserts gone?
Next Topic: resize varray
Goto Forum:

Current Time: Tue Aug 22 11:36:34 CDT 2017

Total time taken to generate the page: 0.01570 seconds