PLS-00201: identifier 'SYS.DBMS_AQADM' must be declared during import
882501Apr 26 2012 — edited Apr 26 2012Hi,
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