Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
A working example of UTL_HTTP.REQUEST, please! — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

A working example of UTL_HTTP.REQUEST, please!

Received Response
9
Views
6
Comments
edited Apr 16, 2022 7:51AM in Autonomous Database 6 comments

Summary

Please provide with a complete example of UTL_HTTP.REQUEST, which works on ATP

Content

I am totally stuck with my inability to make an API call from PL/SQL running on ATP.

HTTPS requests result in unresolvable (on ATP, since I can't upload certificate files) "Certificate validation failure":

ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1810 ORA-29024: Certificate validation failure ORA-06512: at "SYS.UTL_HTTP", line 639 ORA-06512: at "SYS.UTL_HTTP", line 1750 ORA-06512: at line 1

HTTP requests result in ORA-01031: insufficient privileges":

ORA-01031: insufficient privileges ORA-06512: at "SYS.UTL_HTTP", line 1810 ORA-06512: at "SYS.UTL_HTTP", line 136 ORA-06512: at "SYS.UTL_HTTP", line 1745 ORA-06512: at line 1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!