OraFAQ Forum: Forms » Sending sms to Mobile Phone Using API in Pl Sql

Home » Developer & Programmer » Forms » Sending sms to Mobile Phone Using API in Pl Sql (oracle forms 11gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sending sms to Mobile Phone Using API in Pl Sql [message #676942]

Wed, 31 July 2019 05:12

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 2095 times)

Report message to a moderator

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

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

Report message to a moderator

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

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

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.

Report message to a moderator

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

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

Senior Member
Account Moderator

Also read WHEN OTHERS.

Report message to a moderator

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

John Watson
Messages: 8962
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>

Report message to a moderator

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

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?

Report message to a moderator

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

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.

Report message to a moderator

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

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

Senior Member
Account Moderator

set define off

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 01:10:36 CST 2024