1 Reply Latest reply on Sep 13, 2013 5:49 AM by Billy~Verreynne

    Unable to establish a SSL connection using UTL_HTTP




      I am unable to establish a SSL connection using UTL_HTTP.


      The certificate is imported in Oracle Wallet.


      I am using:





      I get the error:

      ORA-29273: HTTP request failed

      ORA-06512: at "SYS.UTL_HTTP", line 1130

      ORA-29259: end-of-input reached

      ORA-06512: at line 6

      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.


      If I don't use the set_wallet, I get an "ORA-29024: Certificate validation failure", so I guess that the connection and certificate is ok?


      How can I debug this?



        • 1. Re: Unable to establish a SSL connection using UTL_HTTP

          I've seen this error before when the SSL handshaking fails.


          Can you turn on logging on the https server to trace the incoming https call from your PL/SQL code?


          If not (e.g. https server is a 3rd party), then I suggest running a browser (Firefox or Chrome) on the Oracle db server, setting its wallet to match the exact contents (and nothing more) of your Oracle wallet, enable http header tracing, and make the https call via the browser.