OraFAQ Forum: Forms » SMS from oracle 6i

Home » Developer & Programmer » Forms » SMS from oracle 6i (Win XP)

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

Re: SMS from oracle 6i [message #611096 is a reply to message #611095]

Thu, 27 March 2014 11:06

cookiemonster
Messages: 13919
Registered: September 2008
Location: Rainy Manchester

Senior Member

You could try comparing it with the example mehboob110233 gave earlier.

Report message to a moderator

Re: SMS from oracle 6i [message #611097 is a reply to message #611095]

Thu, 27 March 2014 11:06

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thats why I need help from this forum.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611098 is a reply to message #611097]

Thu, 27 March 2014 11:09

cookiemonster
Messages: 13919
Registered: September 2008
Location: Rainy Manchester

Senior Member

See my response above.

Report message to a moderator

Re: SMS from oracle 6i [message #611099 is a reply to message #611098]

Thu, 27 March 2014 11:16

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

Report message to a moderator

Re: SMS from oracle 6i [message #611100 is a reply to message #611099]

Thu, 27 March 2014 11:25

cookiemonster
Messages: 13919
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.

Report message to a moderator

Re: SMS from oracle 6i [message #611102 is a reply to message #611100]

Thu, 27 March 2014 11:58

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

Report message to a moderator

Re: SMS from oracle 6i [message #611103 is a reply to message #611102]

Thu, 27 March 2014 12:06

cookiemonster
Messages: 13919
Registered: September 2008
Location: Rainy Manchester

Senior Member

Did you use LF's method to produce a string using your data?

Report message to a moderator

Re: SMS from oracle 6i [message #611104 is a reply to message #611103]

Thu, 27 March 2014 12:09

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Yes But its not working.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611105 is a reply to message #611104]

Thu, 27 March 2014 12:45

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

Report message to a moderator

Re: SMS from oracle 6i [message #611113 is a reply to message #611104]

Thu, 27 March 2014 13:26

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;

Report message to a moderator

Re: SMS from oracle 6i [message #611127 is a reply to message #611113]

Thu, 27 March 2014 22:11

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thanks All for your help.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #661333 is a reply to message #611127]

Wed, 15 March 2017 00:39

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

Report message to a moderator

Re: SMS from oracle 6i [message #661371 is a reply to message #661333]

Thu, 16 March 2017 04:58

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

Keep it open before start of the module to send sms

Report message to a moderator

Pages (2): [ « ‹ 1 2]

Previous Topic:	View Creation by Using Form Button
Next Topic:	CI tools for oracle forms 12c

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 10:43:53 CDT 2024