Home » SQL & PL/SQL » SQL & PL/SQL » Sending SMS through Oracle Database
Sending SMS through Oracle Database [message #193388] Sat, 16 September 2006 02:01 Go to next message
sarfraz_attari
Messages: 123
Registered: July 2005
Senior Member
Dear all

I have a Database of My all customers Mobile Nos I want to send SMS to all customer from Oracle Database using Pl/SQL or any inbuilt Oracle Package, if available or through Oracle forms

Pl Advice How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed

thanks

Sarfraz
Re: Sending SMS through Oracle Database [message #193399 is a reply to message #193388] Sat, 16 September 2006 03:53 Go to previous messageGo to next message
Liza79
Messages: 74
Registered: September 2006
Member
i once had this requirement a few years back, but i was very lucky that the telecom company for our customers was supporting email SMS. Means if we send an email on the number like number@telecom.com the company forward it to the phone as SMS.
so that made my life very easy. i just had to send an email using UTL_SMTP package for PL/SQL to the numbers of customers.

I will also look forward to the answer of this question Smile
Re: Sending SMS through Oracle Database [message #193414 is a reply to message #193388] Sat, 16 September 2006 07:41 Go to previous messageGo to next message
gojko
Messages: 18
Registered: September 2006
Location: London
Junior Member
sarfraz_attari wrote on Sat, 16 September 2006 08:01

Dear all

Pl Advice How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed

thanks

Sarfraz


My clients are using Kapow (http://www.kapow.co.uk/) to send SMS via HTTP, so you can use UTL_HTTP from the database to do it, for example. Sending is relatively simple, you just have to request an URL containing your system username, password, target sms number and the message.

Gojko
http://www.gojko.com
Re: Sending SMS through Oracle Database [message #461799 is a reply to message #193388] Mon, 21 June 2010 09:57 Go to previous messageGo to next message
carolynjoseph
Messages: 1
Registered: June 2010
Junior Member
sarfraz_attari wrote on Fri, 15 September 2006 21:01
Dear all

I have a Database of My all customers Mobile Nos I want to send SMS to all customer from Oracle Database using Pl/SQL or any inbuilt Oracle Package, if available or through Oracle forms

Pl Advice How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed

thanks

Sarfraz


You need a professional Wire2air SMS Gateway software. Use this software with Oracle database to send sms from your computer. You can now more details on the site of wire2air: wire2air.com
Re: Sending SMS through Oracle Database [message #461838 is a reply to message #461799] Mon, 21 June 2010 14:37 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
set up a table of your clients cell phone number and send an HTML email to them. For example verizon would be 12345678900@vtext.com. A list of other ones we use are

Alltel: phonenumber@message.alltel.com
AT&T: phonenumber@txt.att.net
Nextel: phonenumber@messaging.nextel.com
Sprint: phonenumber@messaging.sprintpcs.com
SunCom: phonenumber@tms.suncom.com
T-mobile: phonenumber@tmomail.net
VoiceStream: phonenumber@voicestream.net
Verizon: phonenumber@vtext.com <============= ( for text only)

I say HTML email because about half the companies do not display correctly if you send it as plain text.

Re: Sending SMS through Oracle Database [message #461861 is a reply to message #193388] Tue, 22 June 2010 00:05 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
1/ Dont you think so sending too many email from PL/SQL will make too much processing network traffic.
2/ OP can consider Java source as an option to have interface with SMS.
Re: Sending SMS through Oracle Database [message #461870 is a reply to message #461838] Tue, 22 June 2010 00:58 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Bill B wrote on Mon, 21 June 2010 21:37
set up a table of your clients cell phone number and send an HTML email to them.

Do you really want take responsibility of keeping track of people switching providers whilst keeping their number? Not sure if that is possible in the US, but here it is quite common.
Re: Sending SMS through Oracle Database [message #462335 is a reply to message #461870] Wed, 23 June 2010 10:33 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
In 2 years, I have not had one user change their vendor and if they do it is their responsibility to notify the administrator.
Re: Sending SMS through Oracle Database [message #644118 is a reply to message #193388] Wed, 28 October 2015 06:10 Go to previous messageGo to next message
jagadekar
Messages: 9
Registered: July 2013
Junior Member
Hi Sarfraz,

have you done this?

If yes please post the solution here.
Re: Sending SMS through Oracle Database [message #644124 is a reply to message #644118] Wed, 28 October 2015 07:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you search for and check the provided solution?

Re: Sending SMS through Oracle Database [message #644126 is a reply to message #644124] Wed, 28 October 2015 07:28 Go to previous messageGo to next message
jagadekar
Messages: 9
Registered: July 2013
Junior Member
Hi,

through send an email using UTL_SMTP package?

For testing I sent one email manually like below.

+91xxxxxxxxxx@ideacellular.com

But it shows delivery failure.
Re: Sending SMS through Oracle Database [message #644127 is a reply to message #644126] Wed, 28 October 2015 07:38 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
You sent it to the wrong email address. The correct number for the email to sms is

xxxxxxxxx@ideacellular.net

You ONLY send the telephone number like you were using a local phone on their service
Re: Sending SMS through Oracle Database [message #644129 is a reply to message #644127] Wed, 28 October 2015 07:52 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
If you want a fairly complete list of the email to sms address, see the following site

http://www.emailtextmessages.com/
Re: Sending SMS through Oracle Database [message #644130 is a reply to message #644127] Wed, 28 October 2015 07:57 Go to previous messageGo to next message
jagadekar
Messages: 9
Registered: July 2013
Junior Member
Thanks.

Now I sent manual email to xxxxxxxxxx@ideacellular.net.

Email sent successfully. But SMS not yet received to that mobile.
Re: Sending SMS through Oracle Database [message #644131 is a reply to message #644130] Wed, 28 October 2015 08:07 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
jagadekar wrote on Wed, 28 October 2015 05:57
Thanks.

Now I sent manual email to xxxxxxxxxx@ideacellular.net.

Email sent successfully. But SMS not yet received to that mobile.


Does Idea Cellular support such a service?
Re: Sending SMS through Oracle Database [message #644133 is a reply to message #644131] Wed, 28 October 2015 08:24 Go to previous messageGo to next message
jagadekar
Messages: 9
Registered: July 2013
Junior Member
Hi,

Don't know that. how to know will it support or not?
Re: Sending SMS through Oracle Database [message #644135 is a reply to message #644133] Wed, 28 October 2015 08:26 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
jagadekar wrote on Wed, 28 October 2015 06:24
Hi,

Don't know that. how to know will it support or not?


Call Idea Cellular Tech Support or find answer on their website
Re: Sending SMS through Oracle Database [message #644136 is a reply to message #644135] Wed, 28 October 2015 08:27 Go to previous messageGo to next message
jagadekar
Messages: 9
Registered: July 2013
Junior Member
Ok, Thanks
Re: Sending SMS through Oracle Database [message #644140 is a reply to message #644135] Wed, 28 October 2015 08:44 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
I checked on the web and I saw a couple of notes that said that they do not support email to sms, however when I went on the ideacellular website to see if they had the function, I could never connect. They might be down or unavailable.
Re: Sending SMS through Oracle Database [message #644166 is a reply to message #644140] Wed, 28 October 2015 23:45 Go to previous messageGo to next message
jagadekar
Messages: 9
Registered: July 2013
Junior Member
OH!

Then how to sent sms through oracle?

Are there any alternative ways?
Re: Sending SMS through Oracle Database [message #644167 is a reply to message #644166] Wed, 28 October 2015 23:51 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
jagadekar wrote on Wed, 28 October 2015 21:45
OH!

Then how to sent sms through oracle?

Are there any alternative ways?


Oracle knows nothing about SMS.

post proof that I am incorrect.
Re: Sending SMS through Oracle Database [message #644183 is a reply to message #644166] Thu, 29 October 2015 06:49 Go to previous messageGo to next message
EdStevens
Messages: 707
Registered: September 2013
Senior Member
jagadekar wrote on Wed, 28 October 2015 23:45
OH!

Then how to sent sms through oracle?

Are there any alternative ways?


I see that you sent this as a response to Bill B in message #644140, where he said
Quote:
I checked on the web and I saw a couple of notes that said that they do not support email to sms

So what alternative ways can you imagine to send an sms message to a system that does not support sms messaging?
Re: Sending SMS through Oracle Database [message #644187 is a reply to message #644183] Thu, 29 October 2015 07:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just the usual
- I want to do this.
- This is not possible.
- Any workaround?

Smile

Re: Sending SMS through Oracle Database [message #644188 is a reply to message #644187] Thu, 29 October 2015 07:37 Go to previous messageGo to next message
jagadekar
Messages: 9
Registered: July 2013
Junior Member
Not like that.

first send mail to xxxxxxxxxx@ideacellular.net then network provider will send them sms.

People told that this is not possible. So I just asked are there any alternatives? means, with out send mail to xxxxxxxxxx@ideacellular.net.

Re: Sending SMS through Oracle Database [message #644192 is a reply to message #644188] Thu, 29 October 2015 08:26 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Yes, there is one additional option. There are services out there that you send a phone number and the message and they will send an SMS message using SMS. They do not depend on the provider having an email to sms portal. To look it up go into google and use the following search string

sms gateway service

Please be aware that these are NOT a free service and you will have to use a subscription.
Re: Sending SMS through Oracle Database [message #644200 is a reply to message #644192] Thu, 29 October 2015 23:56 Go to previous message
jagadekar
Messages: 9
Registered: July 2013
Junior Member
Thanks Bill,

I will look into that.
Previous Topic: ERROR CODE IS 1 User-Defined Exception Instead of ORA-00001: unique constraint (SCOTT.PK_EMP_UP) vi
Next Topic: Stored Procedure in migrating data
Goto Forum:
  


Current Time: Thu Dec 08 10:12:52 CST 2016

Total time taken to generate the page: 0.09839 seconds