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

REST web service request error

edited Apr 16, 2022 7:50AM in Autonomous Database 3 comments

Summary

REST web service request error in ATP

Content

when I run this query in Oracle cloud ATP ( free tier), i got this error but it works ok in ADW.

select apex_web_service.make_rest_request(
p_url => 'https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.geojson',
p_http_method => 'GET' ) from dual;

 

ORA-29273: HTTP request failed ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 1285 ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 924 ORA-28759: failure to open file ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1148 ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 902 ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 1138 ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 1475 ORA-06512: at "APEX_190200.WWV_FLOW_WEBSERVICES_API", line 416 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!