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: 17
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 5575 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: 68624
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: 68624
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: 68624
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: 17
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: 21806
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: 17
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: 21806
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: 17
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: 615
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 messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
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
Re: Send SMS using Oracle Forms 6i [message #632102 is a reply to message #594587] Sun, 25 January 2015 00:14 Go to previous messageGo to next message
hasanur
Messages: 1
Registered: July 2010
Location: Dhaka
Junior Member
Hi,
using oracle db, oracle forms 6i, SMS caster(free) and a modem you can Easily send SMS to mobile.
You can contact me [Edit MC: mail removed].
mail subject will be 'send SMS from oracle' and please mention your location.

Thanks

[Updated on: Sun, 25 January 2015 01:39] by Moderator

Report message to a moderator

Re: Send SMS using Oracle Forms 6i [message #632106 is a reply to message #632102] Sun, 25 January 2015 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is not the place to try to get job.
Post and help for free or forget.

Re: Send SMS using Oracle Forms 6i [message #661336 is a reply to message #611791] Wed, 15 March 2017 06:56 Go to previous messageGo to next message
goharshamke@yahoo.com
Messages: 14
Registered: July 2008
Junior Member
Have you found solution to close sms caster
-------------------------
mehboob110233 wrote on Wed, 09 April 2014 11:07
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
---------------
Re: Send SMS using Oracle Forms 6i [message #674621 is a reply to message #611791] Wed, 06 February 2019 05:10 Go to previous messageGo to next message
Shahid Murtaza
Messages: 1
Registered: February 2019
Junior Member
Sir please same thing i want to do.
Please help.
Re: Send SMS using Oracle Forms 6i [message #674776 is a reply to message #577195] Sat, 16 February 2019 01:48 Go to previous messageGo to next message
Sporadic
Messages: 17
Registered: January 2007
Location: Faisalabad
Junior Member

Already Posted!

[Updated on: Sat, 16 February 2019 01:50]

Report message to a moderator

Re: Send SMS using Oracle Forms 6i [message #674777 is a reply to message #611791] Sat, 16 February 2019 02:02 Go to previous messageGo to next message
Sporadic
Messages: 17
Registered: January 2007
Location: Faisalabad
Junior Member

mehboob110233 wrote on Wed, 09 April 2014 11:07
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

The most easy option is to use an api available nowadays by many service provider to send sms through database using UTL_HTTP.request builtin.

To enable host command, you need to perform the attached procedure. It is with the help of JAVA, you need to write a java code in database.
  • Attachment: HOST.txt
    (Size: 4.07KB, Downloaded 2322 times)
Re: Send SMS using Oracle Forms 6i [message #674778 is a reply to message #674621] Sat, 16 February 2019 02:03 Go to previous messageGo to next message
Sporadic
Messages: 17
Registered: January 2007
Location: Faisalabad
Junior Member

Shahid Murtaza wrote on Wed, 06 February 2019 16:10
Sir please same thing i want to do.
Please help.
Shahid, Solution is given. Please check.
Re: Send SMS using Oracle Forms 6i [message #681338 is a reply to message #576364] Thu, 09 July 2020 06:28 Go to previous messageGo to next message
sali23707902gmail.com
Messages: 1
Registered: June 2020
Location: KARACHI
Junior Member
Dear Sporadic...!

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


sali2370790@gmial.com

Regards
Syed Saqib Ali
Re: Send SMS using Oracle Forms 6i [message #681889 is a reply to message #681338] Sat, 05 September 2020 14:35 Go to previous messageGo to next message
Farhan ud din
Messages: 32
Registered: October 2018
Location: malakand
Member

Please share fmb file with me
smartkhan79kpk@gmail.com

Also if u get the idea please explain how to send sms from database oracle 6i /10g
Re: Send SMS using Oracle Forms 6i [message #681965 is a reply to message #681889] Thu, 17 September 2020 12:43 Go to previous messageGo to next message
M HANIF
Messages: 20
Registered: April 2019
Junior Member
If anyone have idea to send messages from android mobile, then please share with me
mhphool786@yahoo.com
mhphool786@gmail.com

Thanks in advance....
Re: Send SMS using Oracle Forms 6i [message #681966 is a reply to message #681965] Thu, 17 September 2020 14:59 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This topic is turning into a "me too" one and is, therefore, closed for further discussion.

I suggest anyone - who is interested in how to do that - review what's already been told and apply those suggestions.
Previous Topic: How to launch the login page after the page refresh(F5)
Next Topic: How to restrict paste (ctrl+v) option in any field in oracle forms
Goto Forum:
  


Current Time: Thu Mar 28 04:35:50 CDT 2024