Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

identifier 'DBMS_AQ' must be declared

458914Oct 7 2005 — edited Dec 18 2006
Hi, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2007
Added on Oct 7 2005
5 comments
36,649 views