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