Click here to Skip to main content
15,846,038 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Got a SSL certificate , imported via Oracle Wallet Manager as well as orapki command line.

want to get Json string from https of website ( set the below Json string as random string , you can pick any other Json string )
i have set wallet store of oracle in E:\wallet folder .

I have done certificate ACL creation and adding in oracle .


set define off;


select utl_http.request('https://api.abc.com/flex/status/rest/v2/json/aaa/status/ZH/9854/dep/2015/06/28?appId=d84d17f8&appKey=613e9804c66069a037a10ee671920712&hourOfDay=0&utc=false&codeType=FS', null, 'file:e:\wallet', null) from dual;
off;

Got the error as :

CSS
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-29024: Certificate validation failure
ORA-06512: at line 1
29273. 00000 -  "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.


Unable to get Exact JSon string ...
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900