Dear All,
Re: ORA-29273: HTTP request failed
I wanted to continue with this thread but since it was not possible i am posting a new thread
With reference to the above thread please suggest how we can overcome this ORA-29106 error. We created an oracle wallet and imported the certificate. The statement 'select utl_http.request(url, NULL,wallet_loc,wallet_pwd) from dual' is succesfful.
The issue is when i call a procedure to execute a webservice with utl_http.begin_request function in Oracle Apex version 4.2.
If i dont use set_wallet in the procedure then i am getting certificate validation failure. Once i specify set_wallet then i am getting ORA-29106: Cannot import PKCS #12 wallet in oracle apex. The certificate is PKCS#7 format as when i was creating the file PKCS12 format was not enabled. If i use any other format for the certificate the statement 'select utl_http.request(url, NULL,wallet_loc,wallet_pwd) from dual' is not successful