OraFAQ Forum: SQL & PL/SQL » Sending SMS through Oracle Database

Home » SQL & PL/SQL » SQL & PL/SQL » Sending SMS through Oracle Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sending SMS through Oracle Database [message #193388]

Sat, 16 September 2006 02:01

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

Report message to a moderator

Re: Sending SMS through Oracle Database [message #193399 is a reply to message #193388]

Sat, 16 September 2006 03:53

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

Smile

Report message to a moderator

Re: Sending SMS through Oracle Database [message #193414 is a reply to message #193388]

Sat, 16 September 2006 07:41

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

Report message to a moderator

Re: Sending SMS through Oracle Database [message #461799 is a reply to message #193388]

Mon, 21 June 2010 09:57

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

Report message to a moderator

Re: Sending SMS through Oracle Database [message #461838 is a reply to message #461799]

Mon, 21 June 2010 14:37

Bill B
Messages: 1971
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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #461861 is a reply to message #193388]

Tue, 22 June 2010 00:05

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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #461870 is a reply to message #461838]

Tue, 22 June 2010 00:58

Frank
Messages: 7901
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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #462335 is a reply to message #461870]

Wed, 23 June 2010 10:33

Bill B
Messages: 1971
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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644118 is a reply to message #193388]

Wed, 28 October 2015 06:10

jagadekar
Messages: 9
Registered: July 2013

Junior Member

Hi Sarfraz,

have you done this?

If yes please post the solution here.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644124 is a reply to message #644118]

Wed, 28 October 2015 07:23

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you search for and check the provided solution?

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644126 is a reply to message #644124]

Wed, 28 October 2015 07:28

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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644127 is a reply to message #644126]

Wed, 28 October 2015 07:38

Bill B
Messages: 1971
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

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644129 is a reply to message #644127]

Wed, 28 October 2015 07:52

Bill B
Messages: 1971
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/

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644130 is a reply to message #644127]

Wed, 28 October 2015 07:57

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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644131 is a reply to message #644130]

Wed, 28 October 2015 08:07

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644133 is a reply to message #644131]

Wed, 28 October 2015 08:24

jagadekar
Messages: 9
Registered: July 2013

Junior Member

Hi,

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

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644135 is a reply to message #644133]

Wed, 28 October 2015 08:26

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644136 is a reply to message #644135]

Wed, 28 October 2015 08:27

jagadekar
Messages: 9
Registered: July 2013

Junior Member

Ok, Thanks

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644140 is a reply to message #644135]

Wed, 28 October 2015 08:44

Bill B
Messages: 1971
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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644166 is a reply to message #644140]

Wed, 28 October 2015 23:45

jagadekar
Messages: 9
Registered: July 2013

Junior Member

OH!

Then how to sent sms through oracle?

Are there any alternative ways?

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644167 is a reply to message #644166]

Wed, 28 October 2015 23:51

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644183 is a reply to message #644166]

Thu, 29 October 2015 06:49

EdStevens
Messages: 1377
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?

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644187 is a reply to message #644183]

Thu, 29 October 2015 07:27

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Smile

Smile

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644188 is a reply to message #644187]

Thu, 29 October 2015 07:37

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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644192 is a reply to message #644188]

Thu, 29 October 2015 08:26

Bill B
Messages: 1971
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.

Report message to a moderator

Re: Sending SMS through Oracle Database [message #644200 is a reply to message #644192]

Thu, 29 October 2015 23:56

jagadekar
Messages: 9
Registered: July 2013

Junior Member

Thanks Bill,

I will look into that.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 27 20:38:29 CDT 2026