Subject : How to Send Message From Oracle Database to Mobile Device.
====================================================================

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.

             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 
                         
                         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 
                         Sample File : 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.

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

			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