thank you christian,
but it give a new error now, actually i have configured ldap long before on this dataabse.
the error is below.
ERROR at line 1: ORA-31003: Parent /sys/acls/ already contains child entry ldapacl.xml ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252 ORA-06512: at line 7
kindly guide for workaround.
you did, there already exists an ACL with this name. Therefore, Oracle does not allow you to create another one with the same name. You can either delete the existing ACL before running this code block or modify it. The details are in the docs for the DBMS_NETWORK_ACL_ADMIN package.