Home » Developer & Programmer » Forms » Send SMS using Oracle Forms 6i (Developer 6i, Any OS)
Send SMS using Oracle Forms 6i [message #576364] Mon, 04 February 2013 01:37 Go to next message
Sporadic
Messages: 14
Registered: January 2007
Location: Faisalabad
Junior Member

I have successfully implemented the from which I can send SMS using Forms 6i and any mobile modem connected with OS.
Now you can send SMS using Oracle Forms 6i.

  • Attachment: ora_sms.jpg
    (Size: 20.64KB, Downloaded 839 times)
Re: Send SMS using Oracle Forms 6i [message #576366 is a reply to message #576364] Mon, 04 February 2013 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a FAQ and there are many topics on the subject, please do search.

Regards
Michel
Re: Send SMS using Oracle Forms 6i [message #576942 is a reply to message #576364] Mon, 11 February 2013 03:04 Go to previous messageGo to next message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

Dear Sporadic...!

can u shear the fmb with me..??? or can you show me the demo...of sending sms using Oracle Forms 6i..


Regards
Waqas Mehmood
Re: Send SMS using Oracle Forms 6i [message #576945 is a reply to message #576942] Mon, 11 February 2013 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you search?

Regards
Michel
Re: Send SMS using Oracle Forms 6i [message #576946 is a reply to message #576945] Mon, 11 February 2013 03:33 Go to previous messageGo to next message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

what do mean by search..??

Regards
Waqas Mehmood
Re: Send SMS using Oracle Forms 6i [message #577190 is a reply to message #576364] Wed, 13 February 2013 04:12 Go to previous messageGo to next message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

Dear Sporadic...!

I read your previous post in this forum... and found that you are very supporting and helping member in this fourm. please help me and tell me the procedure that how can i do this.... plz, plz, please brother... i'll be very grateful to you..


Regards
Waqas Mehmood
Re: Send SMS using Oracle Forms 6i [message #577195 is a reply to message #577190] Wed, 13 February 2013 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
found that you are very supporting and helping member in this fourm.


He has never supported or helped anyone in this forum.
Toadying will not help you.
Why do you think this guy who has not posted since one year post this? Just to sell "his" solution; so don't expect he will give you something for free.

Regards
Michel

Re: Send SMS using Oracle Forms 6i [message #579389 is a reply to message #577195] Tue, 12 March 2013 01:30 Go to previous messageGo to next message
Sporadic
Messages: 14
Registered: January 2007
Location: Faisalabad
Junior Member

Michel Cadot wrote on Wed, 13 February 2013 16:23
Quote:
found that you are very supporting and helping member in this fourm.


He has never supported or helped anyone in this forum.
Toadying will not help you.
Why do you think this guy who has not posted since one year post this? Just to sell "his" solution; so don't expect he will give you something for free.

Regards
Michel



Dear Michel,

Please check my previous posts, and you will find the answer of your reply, I never ever hide any knowledge on this forum, which I had, but this is truth, that I am not so much active on this forum, the reason is that, I am busy too much in my daily schedule, even I dont get time to check my daily emails.

Today I checked my emails and found this post, so I intentionally login to reply it. My login Id is "Sporadic", please if you got time, then try to find out its meaning also.

Dear Waqas,

I am using SMS Caster free software to send sms from Oracle Forms and reports. The best thing in this software is that, I can accept arguments through command line, so by using Host function, you can send parameters to SMS caster, that will be attached with GSM Modem and will send sms anywhere, other feature is that, you can send sms of 10000 characters from it successfully.

This was the magic behind this post, and I never ever hide my knowledge on the forum, instead I watched many persons here, who are very much active, but sell solutions here.

Sorry If anyone hurt from my words.

But Michel had done this to me.
Re: Send SMS using Oracle Forms 6i [message #579398 is a reply to message #579389] Tue, 12 March 2013 01:52 Go to previous messageGo to next message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for sharing that information; now we'll have a message to point other people to (when they need assistance with SMS issues).


Sporadic
I watched many persons here, who are very much active, but sell solutions here.

You did? Who are they? I visit this forum on a daily basis for YEARS now, and I remember one situation where someone (not a regular member) wanted to be paid for help he provides here, on the forum (don't mix that up with true consultancy requests or offers - that's different). But "many people"? Huh, that's rather strong wording you used.
Re: Send SMS using Oracle Forms 6i [message #579422 is a reply to message #579398] Tue, 12 March 2013 02:58 Go to previous messageGo to next message
Sporadic
Messages: 14
Registered: January 2007
Location: Faisalabad
Junior Member

Littlefoot wrote on Tue, 12 March 2013 11:52
Thank you for sharing that information; now we'll have a message to point other people to (when they need assistance with SMS issues).


Sporadic
I watched many persons here, who are very much active, but sell solutions here.

You did? Who are they? I visit this forum on a daily basis for YEARS now, and I remember one situation where someone (not a regular member) wanted to be paid for help he provides here, on the forum (don't mix that up with true consultancy requests or offers - that's different). But "many people"? Huh, that's rather strong wording you used.


Then my dear, if some other person, who is not a regular member, did such kind of acts, it does not mean, that all irregular member come here to do business. Michel blamed me for this, even you can check my all previous posts, I am the member of this forum since the last five/six years, and I never ever demanded to be paid for any help. I myself a learner and come here to get knowledge. How a student, who is a learner and get help from others, can demand payments for giving help to others. My only problem is that, I am not so much active here.

And at the end I appologized to everyone for my wordings, and still if you are hurted, then I am sorry.
Re: Send SMS using Oracle Forms 6i [message #594587 is a reply to message #579422] Fri, 30 August 2013 10:40 Go to previous messageGo to next message
mohammad_ibrar
Messages: 16
Registered: August 2013
Location: Pakistan
Junior Member
Dear Experts.

I have a problem...

I am working in school management system. and i have assigned to send sms notification(s)
using gms model (mobile i.e. samsung galaxy s2 Android)...

My operating system is Windows XP...


I am very new... any one please help me

step by step.... or please send me fmb...

Thanx in Advance

Regards...

Mohammad ibrar
mohammad_ibrar@yahoo.com
Re: Send SMS using Oracle Forms 6i [message #594588 is a reply to message #594587] Fri, 30 August 2013 10:41 Go to previous messageGo to next message
mohammad_ibrar
Messages: 16
Registered: August 2013
Location: Pakistan
Junior Member
i am working in Oracle 9i and developer 6i
Re: Send SMS using Oracle Forms 6i [message #595142 is a reply to message #594588] Sat, 07 September 2013 09:52 Go to previous messageGo to next message
mohammad_ibrar
Messages: 16
Registered: August 2013
Location: Pakistan
Junior Member
Assalamo alickum

Dear Experts....


i got a clue for sending sms from oracle forms.

There are a Set of AT commands. using these commands any one can sent and receive SMS from computre to cell phone device.

Any one tell me please

how to connect my gsm modem with my oracle form via ole object
using ms comm control.

and how to sent
messages....


Please help
Re: Send SMS using Oracle Forms 6i [message #595159 is a reply to message #595142] Sun, 08 September 2013 04:40 Go to previous messageGo to next message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sporadic explained how he managed to solve the problem. How about trying his suggestion?
Re: Send SMS using Oracle Forms 6i [message #598962 is a reply to message #576364] Mon, 21 October 2013 01:40 Go to previous messageGo to next message
Sporadic
Messages: 14
Registered: January 2007
Location: Faisalabad
Junior Member

Using MS Comm in OLE Object will make it difficult for sending and recieving sms. I once used it for getting the weights from Cardinal Scale. But failed to implement it on SMS through comm port.

I used sms caster free software, and connect my mobile through USB cable, with the computer, after that using host command, I sent parameters to sms caster software, the help of parameters that sms caster used is available online. You can search through google sms caster for free online.

HOST('C:\Program Files\SMSCaster\smscaster.exe -compose +01'||SMS.MOBILE||' " Customized text = '||MSG||'" -long -start -exit');

Re: Send SMS using Oracle Forms 6i [message #602187 is a reply to message #598962] Sun, 01 December 2013 01:25 Go to previous messageGo to next message
mohammad_ibrar
Messages: 16
Registered: August 2013
Location: Pakistan
Junior Member
Thanx Dear spodiac....

I tried to use smscaster but i have not found any scratch copy of smscaster.

Dear gurus..

any one please tell me how i attach mobile device with server
and as record inserted in any specific table, mobile attached with server, a message broadcast.

Thanx in advance

Re: Send SMS using Oracle Forms 6i [message #602349 is a reply to message #602187] Tue, 03 December 2013 05:02 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 272
Registered: August 2002
Senior Member
You need to create a table like MSgout. which can receive msg from button or somthing. then send message receiver moble via sms server. you need two things.
1. database
2 sms server
Create table Msgout (id number(15) primary key,msgto varchar2(20),msg varchar2(1000),send varchar2(3));
Insert into msgout(123, '+92345678901','Welcome Parensts!......',Yes);
Insert into msgout(124, '+92345678901','Welcome Parensts!......',Yes);

USe OZekimessge server to send this message from database via mobile. or got to ozekimessage server site to find all detail.
Re: Send SMS using Oracle Forms 6i [message #611791 is a reply to message #579389] Wed, 09 April 2014 01:07 Go to previous message
mehboob110233
Messages: 28
Registered: February 2014
Location: Pakistan
Junior Member

dear Sporadic,

how can we use host command from database trigger.
sms caster do work fine in my form but now i want to use it on database trigger.
one more thing when i send host command firstly smscaster run get data start sms
at the end it not close. how can i close it...


dear please focus on use at database trigger if you have any solution please tell me.

Mehboob Alam
Previous Topic: Save Images in Database From Forms - Download it Here
Next Topic: how can I find out only changed records
Goto Forum:
  


Current Time: Wed Sep 17 19:19:52 CDT 2014

Total time taken to generate the page: 0.10570 seconds