Oracle Database Discussions

Hi all,
Someone can help me please, I'm in Spain and since many days i serach on the net to find a similar service to send free sms in spain but without result, can someone help me please and tell me one service that i can use to send sms throught my oracle database, I find the code below but it's only usefull for Indians service SMS :(

Thank you very much
W

CODE BELOW :

Create a PL/SQL Procedure Which using UTL_SMTP Package.

Create or Replace Procedure SEND_SMS
( p_sender in varchar2,
p_recipient in varchar2,
p_message in varchar2)
as
mailcon utl_smtp.connection;
begin
mailcon :=utl_smtp.open_connection('<your Mail Server SMTP Address>');
utl_smtp.helo(,'<your Mail Server SMTP Address>');
utl_smtp.mail(mailcon,p_sender);
utl_smtp.rcpt(mailcon,p_recipient );
utl_smtp.data(mailcon,'From: ' ||p_sender|| utl_tcp.crlf||
'To: ' || p_recipient ||utl_tcp.crlf ||
'Subject: SMS From Database' || utl_tcp.crlf ||
p_message);
utl_smtp.quit(mailcon);
end;

Execute the Procedure:-
exec SEND_SMS(‘rperiyasamy@oneapps.com’, ‘9880143877@airtelkk.com’,’This is my first SMS’);

To Find your Mobile Address:-J
ust send an email from your email account to the Mobile Email of your friend and it will SMSed to your friend mobile phone. It will be delivered in minutes, depending on the email transmission. If the cell is switched off, then the message will be delivered as soon as it comes to the network. Example: If your friend cell number is 9843012345, then your friend's mobile number series is 9843 and so you have to send an email to your friend as 919843012345@bplmobile.com
Discuss Mobile Phones in Ananthapuri Message Board
Use the table to below find out mobile email of our friend.
State / City - India Cellular Operator Mobile Number Series Mobile Email SMS Andhra Pradesh AirTel 9849 919849xxxxxx@airtelap.com
Andhra Pradesh Idea Cellular 9848 9848xxxxxx@ideacellular.net
Chennai Skycell / Airtel 9840 919840xxxxxx@airtelchennai.com
Chennai RPG Cellular 9841 9841xxxxxx@rpgmail.net
Delhi Airtel 9810 919810xxxxxx@airtelmail.com
Delhi Hutch 9811 9811xxxxxx@delhi.hutch.co.in
Gujarat Idea Cellular 9824 9824xxxxxx@ideacellular.net
Gujarat Airtel 9898 919898xxxxxx@airtelmail.com
Gujarat Celforce / Fascel 9825 9825xxxxxx@celforce.com
Goa Airtel 9890 919890xxxxxx@airtelmail.com
Goa BPL Mobile 9823 9823xxxxxx@bplmobile.com
Goa Idea Cellular 9822 9822xxxxxx@ideacellular.net
Haryana Airtel 9896 919896xxxxxx@airtelmail.com
Haryana Escotel 9812 9812xxxxxx@escotelmobile.com
Himachal Pradesh Airtel 9816 919816xxxxxx@airtelmail.com
Karnataka Airtel 9845 919845xxxxxx@airtelkk.com
Kerala Airtel 9895 919895xxxxxx@airtelkerala.com
Kerala Escotel 9847 9847xxxxxx@escotelmobile.com
Kerala BPL Mobile 9846 9846xxxxxx@bplmobile.com
Kolkata Airtel 9831 919831xxxxxx@airtelkol.com or
Net 2 Cell

Madhya Pradesh Airtel 9893 919893xxxxxx@airtelmail.com
Maharashtra Airtel 9890 919890xxxxxx@airtelmail.com
Maharashtra BPL Mobile 9823 9823xxxxxx@bplmobile.com
Maharashtra Idea Cellular 9822 9822xxxxxx@ideacellular.net
Mumbai Airtel 9892 919892xxxxxx@airtelmail.com
Mumbai BPL Mobile 9821 9821xxxxxx@bplmobile.com
Punjab Airtel 9815 919815xxxxxx@airtelmail.com
Pondicherry BPL Mobile 9843 9843xxxxxx@bplmobile.com
Tamil Nadu Airtel 9894 919894xxxxxx@airtelmail.com
Tamil Nadu BPL Mobile 9843 919843xxxxxx@bplmobile.com
Tamil Nadu Aircel 9842 9842xxxxxx@airsms.com
Uttar Pradesh (West) Escotel 9837 9837xxxxxx@escotelmobile.com

MSC Code for Cellular Circle Operations
Supported Networks

Airtel: Andhra Pradesh, Madhya Pradesh, Chennai (Skycell), Delhi, Gujarat, Haryana, Himachal Pradesh, Goa, Karnataka, Kerala, Kolkata, Maharashtra, Mumbai, Punjab, Tamil Nadu, Uttar Pradesh (West)
Hutch: Delhi
Escotel: Haryana, Uttar Pradesh (West), Kerala
BPL Mobile: Mumbai, Maharashtra, Kerala, Tamil Nadu, Pondicherry, Goa
Idea Cellular: Andhra Pradesh (Tata), Maharashtra, Goa, Gujarat
RPG Cellular: Chennai
Aircel: Tamil Nadu
Celforce (Fascel): Gujarat

BSNL - Email to Mobile Phone
The Unified Messaging Service from BSNL allows to send SMS messages to all BSNL cell phones in India. You can send SMS emails to BSNL phones as mobilenumber@bsnlumN.com
The email domain is different for each region - bsnlumn.com (North), bsnlums.com (South), bsnlume.com (East) and bsnlumw.com (West).




user471037

Posts: 1
Registered: 12/4/05
Send SMS to India,Kerala,Delhi,TamilNadu,Mumbai
Posted: Dec 4, 2005 11:30 AM in response to: irperiyasamy@ya... Reply


www.igreets.com-Send Free SMS to India,US,Canada,Europe. Send SMS to Kerala, SMS to Airtel,BPL,Hutch,Idea,Cellone,Excel,Reliance,Tata Indicomm,Aircel.Send Free flash Greeting Cards,Malayalam Matrimony,Fun SMS, Love Greetings,Kerala,Malayalam MP3,Malayalam Greeting Cards.