APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX service in OCI - ORA-29273: HTTP request failed ORA-01031: insufficient privileges

Kristijan Walter-OracleNov 30 2023

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,

Added on Nov 30 2023

2 comments

567 views

1 mention