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

SMS from oracle 6i [message #610893]

Tue, 25 March 2014 12:17

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Dear All,

I am new in forum and i want to send sms from oracle 6i form.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #610902 is a reply to message #610893]

Tue, 25 March 2014 12:45

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

Senior Member
Account Moderator

This has already been asked, could you search in it, you will find some solutions.

Report message to a moderator

Re: SMS from oracle 6i [message #610914 is a reply to message #610902]

Tue, 25 March 2014 22:01

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thanks for your reply

Yes i found from last 15 days but i cant solve my problem. Please give me some solution.

Thanks & Regards
Arslan Karamat

Report message to a moderator

Re: SMS from oracle 6i [message #610917 is a reply to message #610914]

Tue, 25 March 2014 23:29

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

Dear Arslan Karamt,

you can smscaster for that.
i use this for sening sms. but it is slow if you find any other solution please help me also at
mahboob30699@gmail.com
mahboob30699@hotmail.com

Report message to a moderator

Re: SMS from oracle 6i [message #610918 is a reply to message #610917]

Tue, 25 March 2014 23:48

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Dear Mehboob

Will You Share Your Code or .fmb file with us and I also use sms causter but when button press code not yet done by me properly.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #610921 is a reply to message #610918]

Wed, 26 March 2014 00:02

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

first you download smscaster install it on your machine then connect your mobile with usb cable.
after on button press here is code to use

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

this is my mobile number given in this command...

Report message to a moderator

Re: SMS from oracle 6i [message #610926 is a reply to message #610921]

Wed, 26 March 2014 00:38

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thanks for Your Reply

Its Working fine.

Thanks & Regards
Arslan Karamat

Report message to a moderator

Re: SMS from oracle 6i [message #610927 is a reply to message #610926]

Wed, 26 March 2014 00:40

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

Dear Arslan,

How you solve your problem please tell me.
if you found best solution then also...

Report message to a moderator

Re: SMS from oracle 6i [message #610931 is a reply to message #610927]

Wed, 26 March 2014 02:27

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Dear Mehboob

I Copy Your code in when button press and click on button and its work. But ii cant try it on data fields. I will try on it with in one or two days.

What is your problem.

Thanks & Regards

Report message to a moderator

Re: SMS from oracle 6i [message #610949 is a reply to message #610931]

Wed, 26 March 2014 05:13

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Dear All

I tried the above command individually and its works but when I Create a Table and put data in it and concate blocks in host command it does not work. Please Help.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #610951 is a reply to message #610949]

Wed, 26 March 2014 05:26

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Display HOST string on the screen so that you'd see what you produced. Hopefully, you'll see what's wrong.

Report message to a moderator

Re: SMS from oracle 6i [message #610954 is a reply to message #610951]

Wed, 26 March 2014 05:40

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thanks for Reply Little Foot

I attached my .fmb file with msg please correct it and make a command.

Thanks & Regards
Arslan Karamat

Attachment: SMS.fmb
(Size: 52.00KB, Downloaded 2955 times)

Report message to a moderator

Re: SMS from oracle 6i [message #610959 is a reply to message #610954]

Wed, 26 March 2014 05:46

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

No, thank you.

Report message to a moderator

Re: SMS from oracle 6i [message #610972 is a reply to message #610959]

Wed, 26 March 2014 06:40

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thanks for your reply

please correct the code and Thanx in advance.

Thanks & Regards
Arslan Karamat

Report message to a moderator

Re: SMS from oracle 6i [message #610973 is a reply to message #610972]

Wed, 26 March 2014 06:47

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I said I will not do that. Why wouldn't you
me

Display HOST string on the screen so that you'd see what you produced.

Report message to a moderator

Re: SMS from oracle 6i [message #610975 is a reply to message #610973]

Wed, 26 March 2014 06:57

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

That is string

DECLARE
PATH VARCHAR2(200);
SMS VARCHAR2(50);
TXT VARCHAR2(200);
BEGIN
PATH := 'C:\Program Files\SMSCaster\smscaster.exe';
SELECT MSG_NUM, MSG_TXT INTO SMS, TXT FROM MSGOUT
WHERE MSGID=:MSGID;
host(PATH|| '-compose'||SMS || TXT || '-start -exit');
END;

Thanx & Regard
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #610977 is a reply to message #610975]

Wed, 26 March 2014 07:03

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

No, this is PL/SQL code that is supposed to send an SMS. I told you to display contents of the HOST command - everything that's between the brackets: host (<display this>);

How? Use another variable, such as

declare 
  l_host_string varchar2(500);
  ...
begin
  ...
  l_host_string := PATH|| '-compose'||SMS || TXT || '-start -exit';
  message(l_host_string);
end;

If it turns out to be too large to view it, create a multi-line text item and put l_host_string into it, such as

:block.host_string := l_host_string;

Report message to a moderator

Re: SMS from oracle 6i [message #610978 is a reply to message #610977]

Wed, 26 March 2014 07:44

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thanks for Your Reply

But Icant Understand what you need from me for information I Create a table That is as under and i want when sms buton press sms will be send by sms caster.

Thanks & regards
Arslan

Attachment: MSG.jpg
(Size: 213.29KB, Downloaded 2461 times)

Report message to a moderator

Re: SMS from oracle 6i [message #610984 is a reply to message #610949]

Wed, 26 March 2014 08:48

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I understood that. However, you said

Arslan wrote on Wed, 26 March 2014 11:13

I tried the above command individually and its works but when I Create a Table and put data in it and concate blocks in host command it does not work. Please Help.

I'm trying to help you the best I can (which excludes me writing your form), but it seems that I'm unable to. Wait until someone else joins the discussion as he/she might have different/better ideas & approach to your problem.

Report message to a moderator

Re: SMS from oracle 6i [message #611047 is a reply to message #610984]

Thu, 27 March 2014 05:17

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

This is not work

I only want to need that how we can put data in os software with host command.

So please will you give some examples of host.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611049 is a reply to message #611047]

Thu, 27 March 2014 05:30

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why, but WHY do you refuse to follow my advice?

This is what you are doing now:

SQL> DECLARE
  2    PATH VARCHAR2(200);
  3    SMS VARCHAR2(50) := 'This is SMS';
  4    TXT VARCHAR2(200):= 'This is TXT';
  5    l_str varchar2(200);
  6  BEGIN
  7    PATH := 'C:\Program Files\SMSCaster\smscaster.exe';
  8    l_str := PATH|| '-compose'||SMS || TXT || '-start -exit';
  9    dbms_output.put_line(l_str);
 10  END;
 11  /
C:\Program Files\SMSCaster\smscaster.exe-composeThis is SMSThis is TXT-start -exit

PL/SQL procedure successfully completed.

SQL>

As HOST runs operating system commands, make sure that you can do that task at the operating system command prompt. Therefore, what is the result of

C:\Program Files\SMSCaster\smscaster.exe-composeThis is SMSThis is TXT-start -exit

when you run it at the OS command prompt? To me, it looks rather invalid and I'd take some steps to fix what is obviously wrong.

However, feel free to disagree with what I said.

Report message to a moderator

Re: SMS from oracle 6i [message #611054 is a reply to message #611049]

Thu, 27 March 2014 06:41

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thanks for your reply

But when I wrote it in when button press trigger I take error bad command or file name.
Following is the code:
DECLARE
PATH VARCHAR2(200);
SMS VARCHAR2(50) := 'This is SMS';
TXT VARCHAR2(200):= 'This is TXT';
l_str varchar2(200);
BEGIN
PATH := 'C:\Program Files\SMSCaster\smscaster.exe';
sms := 03211234567;
txt := 'asdf';
l_str := PATH || '-compose'|| SMS || TXT || '-start -exit';
host(l_str);
END;

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611055 is a reply to message #611054]

Thu, 27 March 2014 06:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You can lead some folks to knowledge; but you can not make them think.

Report message to a moderator

Re: SMS from oracle 6i [message #611057 is a reply to message #611054]

Thu, 27 March 2014 06:49

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

Senior Member

If I was you I'd give up and ask someone vaguely competent to do this for you.
LF has pointed what the command you are constructing ends up as. He has pointed out it's obviously wrong.
Anyone with working eyes can tell it's obviously wrong.
This will not work until you fix it.

Report message to a moderator

Re: SMS from oracle 6i [message #611058 is a reply to message #611055]

Thu, 27 March 2014 06:49

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Black Swan

If you have any idea then share it with us.

Thanks & regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611061 is a reply to message #611058]

Thu, 27 March 2014 06:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

whenyoudothingswrongtheydonotworkasdesired

Report message to a moderator

Re: SMS from oracle 6i [message #611062 is a reply to message #611061]

Thu, 27 March 2014 07:00

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Thanks for your Advice

I accept that I am wrong Then please you give right solution for my problem.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611063 is a reply to message #611062]

Thu, 27 March 2014 07:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://idioms.thefreedictionary.com/There's+none+so+blind+as+those+who+will+not+see

Report message to a moderator

Re: SMS from oracle 6i [message #611065 is a reply to message #611063]

Thu, 27 March 2014 07:13

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

You Only Laugh on Others

Will you help any one in difficulty.

I dont want to ask any thing else

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611066 is a reply to message #611065]

Thu, 27 March 2014 07:43

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

Senior Member

Are you really, seriously telling us that you've looked at the generated command LF put in this post and you can't see anything wrong with it?

Report message to a moderator

Re: SMS from oracle 6i [message #611074 is a reply to message #611066]

Thu, 27 March 2014 08:46

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Please anyone give the solution

Thnaks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611079 is a reply to message #611074]

Thu, 27 March 2014 08:53

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

Senior Member

Answer my question

Report message to a moderator

Re: SMS from oracle 6i [message #611087 is a reply to message #611079]

Thu, 27 March 2014 10:12

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Yes Actually I am Student of Oracle

And Newly join oracle.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611089 is a reply to message #611066]

Thu, 27 March 2014 10:14

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

Senior Member

This question:
cookiemonster wrote on Thu, 27 March 2014 12:43

Are you really, seriously telling us that you've looked at the generated command LF put in this post and you can't see anything wrong with it?

Report message to a moderator

Re: SMS from oracle 6i [message #611090 is a reply to message #611089]

Thu, 27 March 2014 10:23

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

Now Will you Please give ansawer

my Question.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611091 is a reply to message #611090]

Thu, 27 March 2014 10:32

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

Senior Member

You haven't answered my question.

Report message to a moderator

Re: SMS from oracle 6i [message #611092 is a reply to message #611091]

Thu, 27 March 2014 10:38

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

will you elaborate your question

I realy cant understand

My english is not so strong.

Thanks & Regards
Arslan

Report message to a moderator

Re: SMS from oracle 6i [message #611093 is a reply to message #611049]

Thu, 27 March 2014 10:48

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

Senior Member

Can you see anything wrong with this:

C:\Program Files\SMSCaster\smscaster.exe-composeThis is SMSThis is TXT-start -exit

Report message to a moderator

Re: SMS from oracle 6i [message #611094 is a reply to message #611093]

Thu, 27 March 2014 11:01

Arslan
Messages: 42
Registered: March 2014
Location: Pakistan

Member

No I dont know

I cant get any thing wrong init I used it and its not work.

Thanks & Regards
Arslan

Report message to a moderator

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

Thu, 27 March 2014 11:04

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

Senior Member

So you've got no idea what a valid call to smscaster.exe looks like?

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: Sun Sep 21 20:29:03 CDT 2025