Oracle Database 19c Enterprise Edition Release 19.0.0.0.0, ORDS 20.3.0.r3011819
I was able to create a REST Module that is available via browser.
If I try to query it, I get this error:
SELECT utl_http.request('https://[URL]/TEST_REST/')) FROM dual;
ORA-29273: HTTP-Anforderung nicht erfolgreich
ORA-06512: in "SYS.UTL_HTTP", Zeile 1530
ORA-24247: Netzwerkzugriff von Access Control-Liste (ACL) abgelehnt
ORA-06512: in "SYS.UTL_HTTP", Zeile 380
ORA-06512: in "SYS.UTL_HTTP", Zeile 1470
ORA-06512: in Zeile 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.
I inserted the URL into the ACL but the error remains. How can I make it work?