How to Fix PLS-00201: identifier 'DBMS_AQ' must be declared

_____________________________________________________________________________________________________________________

Error Description:
Procedure compilation failed with following error.
PLS-00201: identifier 'DBMS_AQ' must be declared

Solution Description
You have to grant the execute privilege on package DBMS_AQ to the particular user who owns the procedure.
SQL> alter procedure usr.MSG_RESUBMIT compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE USR.MSG_RESUBMIT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
8/21     PL/SQL: Item ignored
8/21     PLS-00201: identifier 'DBMS_AQ' must be declared

SQL> grant execute on DBMS_AQ to usr;

Grant succeeded.

SQL> grant execute on DBMS_AQ to usr;

Grant succeeded.

SQL> alter procedure usr.MSG_RESUBMIT compile;

Procedure altered.

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google