identifier 'DBMS_AQ' must be declared
458914Oct 7 2005 — edited Dec 18 2006Hi, Can somebody help me solving this problem. I am trying to create a procedure to enqueue the message, but gives the following error. Also aquser is unable to view the Types in DBMS_AQ package, but is able to view the procedures. Not sure if the privileges problem. Your help will be much appreciated.
Cheers
Naveen
------- -----------------------------------------------------------------
4/19 PLS-00201: identifier 'DBMS_AQ' must be declared
4/19 PL/SQL: Item ignored
5/22 PLS-00201: identifier 'DBMS_AQ' must be declared
5/22 PL/SQL: Item ignored
7/11 PLS-00201: identifier 'PABSE_AQADMIN.MESSAGE_TYP' must be
declared
7/11 PL/SQL: Item ignored
8/14 PLS-00201: identifier 'DBMS_AQ' must be declared
8/14 PL/SQL: Item ignored
2/3 PLS-00320: the declaration of the type of this expression is
INE/COL ERROR
------- -----------------------------------------------------------------
incomplete or malformed
2/3 PL/SQL: Statement ignored
3/3 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
3/3 PL/SQL: Statement ignored
4/3 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
4/3 PL/SQL: Statement ignored
INE/COL ERROR
------- -----------------------------------------------------------------
5/3 PL/SQL: Statement ignored
6/35 PLS-00320: the declaration of the type of this expression is
incomplete or malformed