Skip to Main Content

Oracle Database Discussions

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!

PLS-00201: identifier 'SYS.DBMS_AQADM' must be declared during import

882501Apr 26 2012 — edited Apr 26 2012
Hi,

We are getting the error during the import

Failing sql is:
BEGIN
SYS.DBMS_AQADM.GRANT_QUEUE_PRIVILEGE('ENQUEUE','IMAGING_QUEUE','BENDEV',FALSE);COMMIT; END;
ORA-39083: Object type PROCDEPOBJ_GRANT failed to create with error:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_AQADM' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored


The vendor is telling -> Errors in the Import log indicate that Advanced Queue is not installed.


How to check advanced queue is installed or not ?

Please can you advice me

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2012
Added on Apr 26 2012
6 comments
4,375 views