| send SMS via Oracle 10g [message #546062] |
Mon, 05 March 2012 01:44  |
 |
ramnath1989
Messages: 48
Registered: November 2011
Location: india
|
Member |
|
|
Hi expertise,,,
i am sending { Daily Status } via E-Mail by
Oracle 10g,,,,
now My client want to Receive By sms to his mobile ,,,
Is there any possibilities to sent sms by oracle 10g ,,
if exists pls sent the Code,,,
or any procedure to sent sms via Oracle 10g
help asap
Thanks and Regerds
C.Ramnath
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: send SMS via Oracle 10g [message #546206 is a reply to message #546205] |
Mon, 05 March 2012 14:10  |
 |
sarma.shp
Messages: 111
Registered: February 2012
|
Senior Member |
|
|
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 6 01:38:15 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: ozeking
Enter password:
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> ed
Wrote file afiedt.buf
1* insert into ozekimessageout <receiver,msg,status> values<'+913131454567','h
ai friend','status'>
SQL> /
insert into ozekimessageout <receiver,msg,status> values<'+913131454567','hai fr
iend','status'>
*
ERROR at line 1:
ORA-00926: missing VALUES keyword
SQL>
this is the error i am getting..!
[Updated on: Mon, 05 March 2012 14:12] Report message to a moderator |
|
|
|
| Re: send SMS via Oracle 10g [message #546208 is a reply to message #546206] |
Mon, 05 March 2012 14:18 |
Bill B
Messages: 1971
Registered: December 2004
|
Senior Member |
|
|
do NOT use less then greater then symbols, use parens. Also the software your using costs a minimum of 590 Euros? Do the following.
Send an sms message from the phone to your email address. Then use the from address to send an SMS back to the phone. Using UTIL_MAIL it is free
[Updated on: Mon, 05 March 2012 14:41] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
