OraFAQ Forum: SQL & PL/SQL » Code to Connect to GSM SMSC and send SMS

Home » SQL & PL/SQL » SQL & PL/SQL » Code to Connect to GSM SMSC and send SMS (Oracle pl Sql 10g)

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

Code to Connect to GSM SMSC and send SMS [message #539801]

Wed, 18 January 2012 10:47

shahid17
Messages: 13
Registered: January 2012

Junior Member

Hi,

I work for a GSM operator and I need to create an application that can send SMS to our clients.

Can anyone help with codes for procedures to be created in a oracle database to connect (using SMPP) to our SMSC and send SMS's.

Thanks,

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539804 is a reply to message #539801]

Wed, 18 January 2012 10:56

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

Senior Member
Account Moderator

Did you try to search before posting?
It seems to me this question has been asked sevral times on this forum without speaking about the rest of the web.

Regards
Michel

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539805 is a reply to message #539804]

Wed, 18 January 2012 10:59

shahid17
Messages: 13
Registered: January 2012

Junior Member

Yes Michel, I did search but could not find an answer.

Regards,

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539810 is a reply to message #539805]

Wed, 18 January 2012 11:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I work for a GSM operator and I need to create an application that can send SMS to our clients.
Why is Oracle RDBMS part of any solution?

When your only tool is a hammer, all problems are viewed as nails.
While a hammer is a GREAT tool, it is suboptimal to divide 1 board into 2 pieces

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539811 is a reply to message #539805]

Wed, 18 January 2012 11:05

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

Senior Member
Account Moderator

I just put SMS in the search link above and found this.
I took me about 15 seconds less than the time to write this post!

Regards
Michel

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539821 is a reply to message #539811]

Wed, 18 January 2012 11:51

shahid17
Messages: 13
Registered: January 2012

Junior Member

I need a way of connecting to the SMSC via SMPP and send SMS. I did not see such answer in my search. I do not want to use email to SMS.

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539822 is a reply to message #539821]

Wed, 18 January 2012 11:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I did not see such answer in my search. I do not want to use email to SMS.
Then you require eye examination & new pair of glasses.

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539881 is a reply to message #539822]

Thu, 19 January 2012 01:20

shahid17
Messages: 13
Registered: January 2012

Junior Member

I will do the eye examination & get a new pair of glasses. Since you saw the solution to my query, can you please tell me the link ? Thanks.

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539888 is a reply to message #539881]

Thu, 19 January 2012 01:35

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

Senior Member
Account Moderator

The link is in the link I pointed you to; did you read it?

Regards
Michel

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #539898 is a reply to message #539888]

Thu, 19 January 2012 02:48

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

There is no built-in way to do SMSC/SMPP from PL/SQL.

There seems to be a way in Oracle Application Server Wireless

The other options are to use a Mail gateway, a command line tool started from PL/SQL or implement it on the TCP level with with UTL_TCP.

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #540202 is a reply to message #539898]

Fri, 20 January 2012 12:22

shahid17
Messages: 13
Registered: January 2012

Junior Member

I'm looking at the links and try to find a solution that can suit my requirement. Will update if have any issue. Thank you all.

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #545137 is a reply to message #540202]

Mon, 27 February 2012 08:31

shahid17
Messages: 13
Registered: January 2012

Junior Member

I have tried the diafaan solution and it worked fine for me. I managed to connect my oracle database to Diafaan. Thanks to all

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #545415 is a reply to message #539801]

Wed, 29 February 2012 04:45

mamalik
Messages: 270
Registered: November 2008
Location: Pakistan

Senior Member

Dear Shahid,
Will you like to share you solutions? How did u do this? I also need that.

Regards,
Asif.

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #545423 is a reply to message #545415]

Wed, 29 February 2012 06:22

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

Senior Member
Account Moderator

Did you try to only search?

Regards
Michel

Report message to a moderator

Re: Code to Connect to GSM SMSC and send SMS [message #545444 is a reply to message #545415]

Wed, 29 February 2012 08:55

shahid17
Messages: 13
Registered: January 2012

Junior Member

Dear Asif,

I downloaded Diafaan software from http://www.diafaan.com

I requested an SMPP account in our SMSC and installed Diafaan.

Then from Diafaan, I connected to the SMSC and also to my oracle database.

Below links will help you understand the rest

http://www.diafaan.com/manuals/diafaansmsserver/connect_to_a_database.htm

http://www.diafaan.com/manuals/diafaansmsserver/oracle_database.htm

Message received are directly going to my database and if I need send an sms, I just need to insert a record in messageout table.

Regards,

Report message to a moderator

Previous Topic:	Materialized View-Creation
Next Topic:	Query a table beginning with @

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 18 16:23:29 CDT 2025