|
|
|
|
|
|
|
|
| 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: 8960
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>
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
