Home » Developer & Programmer » Forms » Sending sms to Mobile Phone Using API in Pl Sql (oracle forms 11gR2)
Sending sms to Mobile Phone Using API in Pl Sql [message #676942] Wed, 31 July 2019 05:12 Go to next message
Ace Mirxa
Messages: 9
Registered: March 2019
Junior Member
Hi Exports,
I want To send sms from oracle database by using Cellular network like (Zong , Telenor) I use This code given in Attachment, but got error
FRM-40735:where when_Button_Pressed Trigger raised unhandled exception ORA-29273.

Kindly Give me The Fmb file for sending sms to Mobile or any procedure in pl sql


Thanks in Advance:
Regards: Ace Mirxa
  • Attachment: Capture2.PNG
    (Size: 57.02KB, Downloaded 551 times)
Re: Sending sms to Mobile Phone Using API in Pl Sql [message #676943 is a reply to message #676942] Wed, 31 July 2019 05:17 Go to previous messageGo to next message
Ace Mirxa
Messages: 9
Registered: March 2019
Junior Member
i want step to step procedure because i am new in oracle

thanks in advance
Regards: Ace Mirxa
Re: Sending sms to Mobile Phone Using API in Pl Sql [message #676944 is a reply to message #676942] Wed, 31 July 2019 05:19 Go to previous messageGo to next message
Michel Cadot
Messages: 67847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-29273: HTTP request failed
 *Cause:  The UTL_HTTP package failed to execute the HTTP request.
 *Action: Use get_detailed_sqlerrm to check the detailed error message.
          Fix the error and retry the HTTP request.
Re: Sending sms to Mobile Phone Using API in Pl Sql [message #676945 is a reply to message #676942] Wed, 31 July 2019 05:21 Go to previous messageGo to next message
Michel Cadot
Messages: 67847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also read WHEN OTHERS.

Re: Sending sms to Mobile Phone Using API in Pl Sql [message #676947 is a reply to message #676942] Wed, 31 July 2019 05:33 Go to previous messageGo to next message
John Watson
Messages: 8547
Registered: January 2010
Location: Global Village
Senior Member
First, please use copy/paste to insert your code as text into your posts, not as attachments which many people will not download and are in any case awkward to read. Enclose the text within bb [code] tags, How to use code tags and make your code easier to read

Second, remove your EXCEPTION clause, it is concealing useful information.

Third, there could be any number of reasons why that code is failing. You need to test it in simpler way. For example, this test shows that my database is not configured to accept the digital certificate of the site you are going to:
orclx>
orclx> select utl_http.request('https://telenorcsms.com.pk:27677/corporate_sms2/api/auth.jsp?msisdn=92345506122&password=zahidkhan0000000') from dual;
select utl_http.request('https://telenorcsms.com.pk:27677/corporate_sms2/api/auth.jsp?msisdn=92345506122&password=zahidkhan0000000') from dual
       *
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1501
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1441
ORA-06512: at line 1


orclx>


Re: Sending sms to Mobile Phone Using API in Pl Sql [message #676948 is a reply to message #676947] Wed, 31 July 2019 06:37 Go to previous messageGo to next message
Ace Mirxa
Messages: 9
Registered: March 2019
Junior Member
Thanks Both Of You @Michel And @John

I want to know another thing
that API password and only password has any difference?
Re: Sending sms to Mobile Phone Using API in Pl Sql [message #676949 is a reply to message #676948] Wed, 31 July 2019 06:56 Go to previous messageGo to next message
Ace Mirxa
Messages: 9
Registered: March 2019
Junior Member
Dear @John
In URL my sqlplus, toad , plsql the "&" is indicated as Ampersand while it is "And"

how to get rid from it.
Re: Sending sms to Mobile Phone Using API in Pl Sql [message #676950 is a reply to message #676949] Wed, 31 July 2019 07:11 Go to previous message
Michel Cadot
Messages: 67847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

set define off

Previous Topic: Search field in LOV issue
Next Topic: Write Image from Forms6i to Client local system
Goto Forum:
  


Current Time: Wed May 12 04:18:54 CDT 2021