Thursday, 2 July 2020

PLS-00201: identifier 'DBMS_LOCK' must be declared while compile object

Error while compile object:
SQL> alter PROCEDURE OBIEE.SDLEARNING compile;

Warning: Procedure altered with compilation errors.

Check error details:
SQL> show error
Errors for PROCEDURE OBIEE.SDLEARNING:

LINE/COL ERROR
-------- -----------------------------------------------------------------
62/7 PL/SQL: Statement ignored
62/7 PLS-00201: identifier 'DBMS_LOCK' must be declared


Error due to permission issue , grant execute on dbms_lock to user and retry compile and it works 

SQL> GRANT execute ON DBMS_LOCK TO OBIEE;

Grant succeeded.

SQL> alter PROCEDURE OBIEE.SDLEARNING compile;

Procedure altered.



No comments:

Post a Comment