Error 'PLS-00201: identifier 'DBMS_LOCK' must be declared'

PLS-00201: identifier 'DBMS_LOCK' must be declared

Cause

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

Resolution

Grant permission on the dbms_lock to user/schema.

GRANT execute ON DBMS_LOCK TO "<schema_name>";

SQLPLUS / as sysdba

GRANT execute ON DBMS_LOCK TO <schema_name>

Example:

SQL>grant execute on dbms_lock to SCOTT;