Hello team,
We are facing an issue with APEX hosted in OCI (APEX Service on Autonomous Database):
We can get their route from the server, but not from the database. We added the acl and checked it with SELECT * FROM DBA_NETWORK_ACLS; SELECT * FROM DBA_NETWORK_ACL_PRIVILEGES; that it is well registered. When we try to remove the get from the database, we get an error:
ORA-29273: HTTP request failed
ORA-01031: insufficient privileges
although we have given the user all the necessary privileges. Does the autonomous database have any restrictions on UTL_HTTP because we trigger get on HTTP instead of HTTPS?
Does anyone have an idea how to solve this?
Thanks a lot.
BR,
KW