PLS-00201: identifier ‘DBMS_LOCK’ must be declared

The Oracle schema does not have access to the DBMS_LOCK package.

solution  :

1. Launch an sqplus / as sysdba
2. Connect/logon to the database, using administrative credentials
3. Run the following script:

we are giving grant execute on the packages owner.

commands :

GRANT execute ON DBMS_LOCK TO packages_owner ( schema_name ) ;
have a good day.

Hits: 19

Leave a Reply

Your email address will not be published. Required fields are marked *