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

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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.

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

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