How to Create Oracle AQ in oracle XE 10.2.0.1.0
i am try to create Advanced Queue in oracle xe 10.2.0.1.0 .
for that i need one clarification.whatever i mensiond in the below packeges.
is it required to create Queue?.
if it is required. how we get this in our database.
is this packeges automatically availble whenever instaled the oracle xe 10.2.0.1.0.
1.DBMS_AQ
2.DBMS_AQADM
2. Question: i am try to create AQ in oracle XE 10.2.0.1.0
Fallow the below steps:
1.CREATE USER testq IDENTIFIED BY x;
2.GRANT connect, resource, dba TO testq;
3.GRANT aq_administrator_role, aq_user_role TO testq;
4.GRANT create type TO testq;
After 4 step i execute below sql command.getting the error .
Error is : ORA-00942: table or view does not exist .why i am getting this error.
CREATE OR REPLACE TYPE event_msg_type AS OBJECT (
name VARCHAR2(10),
current_status NUMBER(5),
next_status NUMBER(5)
);
pls help me on this ASAP.