PL/SQL (MOSC)

MOSC Banner

Getting ORA-29276 when trying utl_http.request

edited Jul 29, 2020 5:01AM in PL/SQL (MOSC) 5 commentsAnswered

Hi,

I'm getting ORA-29276 when trying utl_http, here is my request :

select utl_http.request('https://webserviceadresse.com',NULL,'file:///path/to/my/wallet','mywalletpassword' ) from dual;

ORA-29273: échec de demande HTTP

ORA-06512: à "SYS.UTL_HTTP", ligne 1501

ORA-29276: expiration du transfert

ORA-06512: à "SYS.UTL_HTTP", ligne 651

ORA-06512: à "SYS.UTL_HTTP", ligne 1443

ORA-06512: à ligne 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.

the certificate is OK, and the utl_http.request work fine with http but not in https

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center