Home » Developer & Programmer » Forms » SMS from oracle 6i (Win XP)
SMS from oracle 6i [message #610893] Tue, 25 March 2014 12:17 Go to next message
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
Re: SMS from oracle 6i [message #610902 is a reply to message #610893] Tue, 25 March 2014 12:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: SMS from oracle 6i [message #610914 is a reply to message #610902] Tue, 25 March 2014 22:01 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #610917 is a reply to message #610914] Tue, 25 March 2014 23:29 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #610918 is a reply to message #610917] Tue, 25 March 2014 23:48 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #610921 is a reply to message #610918] Wed, 26 March 2014 00:02 Go to previous messageGo to next message
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...
Re: SMS from oracle 6i [message #610926 is a reply to message #610921] Wed, 26 March 2014 00:38 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Thanks for Your Reply


Its Working fine.


Thanks & Regards
Arslan Karamat
Re: SMS from oracle 6i [message #610927 is a reply to message #610926] Wed, 26 March 2014 00:40 Go to previous messageGo to next message
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...
Re: SMS from oracle 6i [message #610931 is a reply to message #610927] Wed, 26 March 2014 02:27 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #610949 is a reply to message #610931] Wed, 26 March 2014 05:13 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #610951 is a reply to message #610949] Wed, 26 March 2014 05:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: SMS from oracle 6i [message #610954 is a reply to message #610951] Wed, 26 March 2014 05:40 Go to previous messageGo to next message
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 2472 times)
Re: SMS from oracle 6i [message #610959 is a reply to message #610954] Wed, 26 March 2014 05:46 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, thank you.
Re: SMS from oracle 6i [message #610972 is a reply to message #610959] Wed, 26 March 2014 06:40 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #610973 is a reply to message #610972] Wed, 26 March 2014 06:47 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: SMS from oracle 6i [message #610975 is a reply to message #610973] Wed, 26 March 2014 06:57 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #610977 is a reply to message #610975] Wed, 26 March 2014 07:03 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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;
Re: SMS from oracle 6i [message #610978 is a reply to message #610977] Wed, 26 March 2014 07:44 Go to previous messageGo to next message
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 2058 times)
Re: SMS from oracle 6i [message #610984 is a reply to message #610949] Wed, 26 March 2014 08:48 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: SMS from oracle 6i [message #611047 is a reply to message #610984] Thu, 27 March 2014 05:17 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #611049 is a reply to message #611047] Thu, 27 March 2014 05:30 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: SMS from oracle 6i [message #611054 is a reply to message #611049] Thu, 27 March 2014 06:41 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #611055 is a reply to message #611054] Thu, 27 March 2014 06:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You can lead some folks to knowledge; but you can not make them think.
Re: SMS from oracle 6i [message #611057 is a reply to message #611054] Thu, 27 March 2014 06:49 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: SMS from oracle 6i [message #611058 is a reply to message #611055] Thu, 27 March 2014 06:49 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Black Swan

If you have any idea then share it with us.

Thanks & regards
Arslan
Re: SMS from oracle 6i [message #611061 is a reply to message #611058] Thu, 27 March 2014 06:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
whenyoudothingswrongtheydonotworkasdesired
Re: SMS from oracle 6i [message #611062 is a reply to message #611061] Thu, 27 March 2014 07:00 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #611063 is a reply to message #611062] Thu, 27 March 2014 07:07 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #611065 is a reply to message #611063] Thu, 27 March 2014 07:13 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #611066 is a reply to message #611065] Thu, 27 March 2014 07:43 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?
Re: SMS from oracle 6i [message #611074 is a reply to message #611066] Thu, 27 March 2014 08:46 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Please anyone give the solution

Thnaks & Regards
Arslan
Re: SMS from oracle 6i [message #611079 is a reply to message #611074] Thu, 27 March 2014 08:53 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Answer my question
Re: SMS from oracle 6i [message #611087 is a reply to message #611079] Thu, 27 March 2014 10:12 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Yes Actually I am Student of Oracle

And Newly join oracle.


Thanks & Regards
Arslan
Re: SMS from oracle 6i [message #611089 is a reply to message #611066] Thu, 27 March 2014 10:14 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?

Re: SMS from oracle 6i [message #611090 is a reply to message #611089] Thu, 27 March 2014 10:23 Go to previous messageGo to next message
Arslan
Messages: 42
Registered: March 2014
Location: Pakistan
Member
Now Will you Please give ansawer

my Question.


Thanks & Regards
Arslan
Re: SMS from oracle 6i [message #611091 is a reply to message #611090] Thu, 27 March 2014 10:32 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You haven't answered my question.
Re: SMS from oracle 6i [message #611092 is a reply to message #611091] Thu, 27 March 2014 10:38 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #611093 is a reply to message #611049] Thu, 27 March 2014 10:48 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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

Re: SMS from oracle 6i [message #611094 is a reply to message #611093] Thu, 27 March 2014 11:01 Go to previous messageGo to next message
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
Re: SMS from oracle 6i [message #611095 is a reply to message #611094] Thu, 27 March 2014 11:04 Go to previous messageGo to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
So you've got no idea what a valid call to smscaster.exe looks like?
Previous Topic: View Creation by Using Form Button
Next Topic: CI tools for oracle forms 12c
Goto Forum:
  


Current Time: Fri Mar 29 03:48:46 CDT 2024