PLS-00201: identifier 'DBMS_AQ' must be declared

ERROR : demantra.notification package body is Invalid

Step 1: Tried to Compile but it is Giving Error

 SQL> ALTER PACKAGE demantra.NOTIFICATION compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors

Errors for PACKAGE BODY DEMANTRA.NOTIFICATION:

LINE/COL ERROR

-------- -----------------------------------------------------------------

866/10   PL/SQL: Statement ignored

866/44   PLS-00201: identifier 'DBMS_AQ' must be declared

1071/28  PL/SQL: Item ignored

1071/28  PLS-00201: identifier 'DBMS_AQ' must be declared

1072/28  PL/SQL: Item ignored

1072/28  PLS-00201: identifier 'DBMS_AQ' must be declared

1073/28  PL/SQL: Item ignored

1073/28  PLS-00201: identifier 'DBMS_AQ' must be declared

1074/28  PL/SQL: Item ignored

1074/28  PLS-00201: identifier 'DBMS_AQ' must be declared

1168/19  PL/SQL: Statement ignored

1168/19  PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

1176/19  PL/SQL: Statement ignored

1176/19  PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

1177/19  PL/SQL: Statement ignored

1177/19  PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

1178/19  PL/SQL: Statement ignored

1178/19  PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

1179/19  PL/SQL: Statement ignored

1179/19  PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

SOLUTION : Execute Below Grants and try to recompile after issuing grants

GRANT EXECUTE ON "SYS"."DBMS_AQ_BQVIEW" TO "DEMANTRA" ;

GRANT EXECUTE ON "SYS"."DBMS_AQADM" TO "DEMANTRA";

GRANT EXECUTE ON "SYS"."DBMS_AQ" TO "DEMANTRA";

ALTER PACKAGE demantra.NOTIFICATION compile body;