Hello,
I'm trying to call an oracle OCI rest api from an APEX page when the create button is pressed. I'm getting this error “ORA-24247: network access denied by access control list (ACL)”.
I'm using apex on cloud that comes with free version of ATP and the apex version is 23.1.0.
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => 'apex_23_01_acl.xml',
description => 'Permissions to access web service',
principal => 'APEX_230100',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL
);
COMMIT;
END;
-- Add Privilege
BEGIN
DBMS_NETWORK_acl_ADMIN.ADD_PRIVILEGE(
acl => 'apex_23_01_acl.xml',
principal => 'APEX_230100',
is_grant => true,
privilege => 'resolve',
start_date => NULL,
end_date => NULL
);
COMMIT;
END;
-- Assign ACL
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => 'apex_23_01_acl.xml',
host => '*.oraclecloud.com',
lower_port => NULL,
upper_port => NULL
);
COMMIT;
END;
I can see the ACL is created and APEX_230100 user have the necessary connect and resolve privileges.
Can you please let me know anything else I needed to do to make this work.
Thanks in Advance.