[ad_1]
I am trying to set up a small Rest API and connect to it from an OCI Autonomous DB. But I am stuck.
This request works:
SELECT apex_web_service.make_rest_request(
p_url => 'https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson'||CHR(38)||'limit=100',
p_http_method => 'GET') JSON
FROM DUAL;
This is a call to an existing public Rest-API (not mine).
This does not work:
SELECT apex_web_service.make_rest_request(
p_url => 'https://raspi.brima.dynv6.net:1880/gettest',
p_http_method => 'GET') JSON
FROM DUAL;
This is my own API. It’s only a “Hello World!” example.
For this call, I get:
ORA-29273: HTTP request failed
ORA-06512: at "APEX_210200.WWV_FLOW_WEB_SERVICES", line 1182
ORA-06512: at "APEX_210200.WWV_FLOW_WEB_SERVICES", line 782
ORA-01031: insufficient privileges
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1209
The same happens when I try to do the request via UTL_HTTP.
I setup an ACE for Host ‘*.brima.dynv6.net’ for my currecnt DB user with privilege CONNECT, but that did not change anything.
Also, why is the first example working without a special ACL configuration?
I don’t understand the problem.
I already looked at this question, but it wasn’t really answered.
Can anyone point me in the right direction?
Thanks & Regards,
Nadine
[ad_2]