Home » Developer & Programmer » Forms » SMS from oracle 6i (Win XP)
Re: SMS from oracle 6i [message #611096 is a reply to message #611095] Thu, 27 March 2014 11:06 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
You could try comparing it with the example mehboob110233 gave earlier.
Re: SMS from oracle 6i [message #611097 is a reply to message #611095] Thu, 27 March 2014 11:06 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Thats why I need help from this forum.


Thanks & Regards
Arslan
Re: SMS from oracle 6i [message #611098 is a reply to message #611097] Thu, 27 March 2014 11:09 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
See my response above.
Re: SMS from oracle 6i [message #611099 is a reply to message #611098] Thu, 27 March 2014 11:16 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Yes I also Use it But I want

host('C:\Program Files (x86)\SMSCaster\smscaster.exe -compose 03226201910 "Customized text " -start -exit');

Field data in color places

But I cant able to make query for it.


Thanks & Regards
Arslan
Re: SMS from oracle 6i [message #611100 is a reply to message #611099] Thu, 27 March 2014 11:25 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can and have made a query.
The problem isn't the query, the problem is how you patch together the command you pass to host.
Now work out what exactly you are passing to host. LF has shown you exactly how to do it.
Re: SMS from oracle 6i [message #611102 is a reply to message #611100] Thu, 27 March 2014 11:58 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
I used the sting made by LF and tried to make own but not working.

Will you make it little bit easier.


Thanks & Regards
Arslan
Re: SMS from oracle 6i [message #611103 is a reply to message #611102] Thu, 27 March 2014 12:06 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Did you use LF's method to produce a string using your data?
Re: SMS from oracle 6i [message #611104 is a reply to message #611103] Thu, 27 March 2014 12:09 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Yes But its not working.


Thanks & Regards
Arslan
Re: SMS from oracle 6i [message #611105 is a reply to message #611104] Thu, 27 March 2014 12:45 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
>Yes But its not working.
code used to form the string was flawed when you first posted it & will remain flawed until you correct it by adding required & expected space characters!
Re: SMS from oracle 6i [message #611113 is a reply to message #611104] Thu, 27 March 2014 13:26 Go to previous messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

DECLARE
PATH VARCHAR2(200);
SMS VARCHAR2(50);
TXT VARCHAR2(200);
host_path varchar(2000);
BEGIN
PATH := 'C:\Program Files (x86)\SMSCaster\smscaster.exe';
--SELECT MSG_NUM, MSG_TXT INTO SMS, TXT FROM MSGOUT
--- WHERE MSGID=:MSGID;
host_path:=(PATH|| ' -compose '||:msg_num ||' "'|| :msg_TXT || '" -start -exit');
-- message(host_path);
--message(host_path);
host(host_path);
END;
Re: SMS from oracle 6i [message #611127 is a reply to message #611113] Thu, 27 March 2014 22:11 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Thanks All for your help.


Thanks & Regards
Arslan
Re: SMS from oracle 6i [message #661333 is a reply to message #611127] Wed, 15 March 2017 00:39 Go to previous messageGo to next message
goharshamke@yahoo.com
Messages: 14
Registered: July 2008
Junior Member
AOA.
Dear All,
After studing all this thread I have implemented SMS using sms caster but when we call sms caster it is opened , send sms and untill we did not close it we can't work in forms6i, as it seems held. 2ndly is it possible that this caster remained opened in backend and when ever required send sms and didn't need to call and close it again and again
Regards,
Gohar
Re: SMS from oracle 6i [message #661371 is a reply to message #661333] Thu, 16 March 2017 04:58 Go to previous message
bluetooth420
Messages: 145
Registered: November 2011
Senior Member
Keep it open before start of the module to send sms
Previous Topic: View Creation by Using Form Button
Next Topic: CI tools for oracle forms 12c
Goto Forum:
  


Current Time: Mon Aug 03 18:22:36 CDT 2020