advanced queueing support

[gundogar]

hi
i have a question about oracle advanced queueing. i have downloaded oracle 8i version 8.1.7 enterprise edition from otn. i dont have a product licence and a metalink account.
i have installed typical version of enterprise edition. the universal installer says that advanced queueing has been installed. but when i look at v$option table i see that it is false and when i try to create a queue_table it says feature not enabled.
after this i run the dbmsaqad.sql script from rdmbs folder
and try again at that time the error message is like this

BEGIN dbms_aqadm.create_queue_table (queue_table => 'AppOne_QTab', multiple_consumers => true, queue_payload_type => 'RAW'); END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "SYS.DBMS_AQADM_SYS" has been invalidated
ORA-04065: not executed, altered or dropped package "SYS.DBMS_AQADM_SYS"
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQADM", line 55
ORA-06512: at line 1


can anyone help me about my question pls
because i am trying to do a graduate project about xml and i need advanced queueing.

 

[gansen]

Recreate the package and try

 

[JigarMD]

Try to recompile the package as user sys or recreate after login as sys.