Greetings,
I'm encountering a challenge with setting up network access for the APEX schema in the Oracle Autonomous Database Free Container. Our goal is to utilize external web services in APEX using apex_web_service.make_rest_request. However, we're facing the error "ORA-24247: network access denied by access control list (ACL)", indicating that we need to configure ACL's.
Our initial approach was to follow articles/documents to configure ACLs for both the calling schema and the APEX_230100 schema. Interestingly, for the APEX installation, this seems to require action on the Container Database (CDB) :
Oracle Support Document 2582658.1
(ORA-29273 ORA-24247: HTTP Request Failed Despite ACL Requests Being Set With the Apex User)https://support.oracle.com/epmos/faces/DocumentDisplay?id=2582658.1
Furthermore, the Oracle documentation (Autonomous Database Serverless Documentation) indicates that "Network ACLs" are "Not available" for this offering. This is perplexing, as our experience suggests otherwise.
After configuring ACL's everything works fine for the basic “utl_http.request” :
select utl_http.request('https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.geojson') from dual ;
But still not for this:
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;
Which will give "ORA-24247: network access denied by access control list (ACL)", a situation that arguably persists until the ACL is applied at the CDB-level for the APEX_230100 schema..
Any insights or suggestions would be greatly appreciated.
Best regards,
Øyvind