DECLARE
l_acl VARCHAR2(100) := ‚apxldapacl.xml‘;
l_desc VARCHAR2(100) := ‚LDAP Authentication for OID‘;
l_principal VARCHAR2(30) := ‚APEX_040200‘; – upper case
l_host VARCHAR2(100) := ‚ldap.loopback.org‘;
BEGIN
– Create the new ACL.
– Also, provide one starter privilege, granting the schema the privilege to connect.
dbms_network_acl_admin.create_acl(l_acl, l_desc, l_principal, TRUE, ‚connect‘);

– Now grant privilege to resolve DNS names.
dbms_network_acl_admin.add_privilege(l_acl, l_principal, TRUE, ‚resolve‘);

– Specify which hosts this ACL applies to.
dbms_network_acl_admin.assign_acl(l_acl, l_host);

COMMIT;
END;