Skip to Main Content
Forums

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.

Create ACL in Oracle APEX always free

Engineerr1983Apr 24 2024 — edited Apr 24 2024

Hi

I'm using APEX always freed tier, I have the following SQL code to create ACL to connect to google API

DECLARE
v_acl_name VARCHAR2(30) := 'apex_23_2_acl.xml';
v_acl_desc VARCHAR2(100) := 'API code';
v_acl_pric VARCHAR2(30) := 'APEX_230200';
v_acl_host VARCHAR2(30) := '*.googleapis.com';
v_acl_port_lower NUMBER;
v_acl_port_upper NUMBER;
BEGIN

dbms_network_acl_admin.create_acl(acl => v_acl_name,
description => v_acl_desc,
principal => v_acl_pric,
is_grant => true,
privilege => 'connect');

dbms_network_acl_admin.add_privilege(acl => v_acl_name,
principal => v_acl_pric,
is_grant => true,
privilege => 'resolve');

dbms_network_acl_admin.assign_acl(acl => v_acl_name,
host => v_acl_host,
lower_port => NULL,
upper_port => NULL);
END

The error is

pls-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared

I saw several posts about this error as shown below:

I also don't have the SYSDBA previliges to Oracle.apex.com.

So, is there any workaround to create ACL inside APEX always free tier? or it must be created in local APEX environment?

Thanks

Comments

Post Details

Added on Apr 24 2024
#accesscontrollist, #acl, #apex, #apex23, #apexalwayesfree, #api, #dbmsnetworkacladmin, #oraclewallet
17 comments
312 views