Issues occurred while creating DataBase Queue for AQ adapter in SOA
ManiFeb 5 2013 — edited Feb 7 2013Hi All,
I am new to AQ adapters,I am trying to create database queue with in the custom user but I got ora-01031 insufficient privileges,actually I follow the below two links
http://askmesoa.blogspot.in/2012/09/working-with-aq-adapter-in-soa.html
http://jamessmith73.wordpress.com/oracle-fusion-middleware/oracle-soa-bpm-11g-blogs/soa-10g/soa-hands-on-4/
When I trying to execute the following code I got ora-01031 insufficient privileges.
BEGIN
-- ----------------------------------------------------
DBMS_AQADM.CREATE_QUEUE_TABLE (
queue_table => 'aq_user.msg_qt'
, queue_payload_type => 'aq_user.message_type'
);
-- ----------------------------------------------------
DBMS_AQADM.CREATE_QUEUE (
queue_name => 'msg_queue'
, queue_table => 'aq_user.msg_qt'
, queue_type => DBMS_AQADM.NORMAL_QUEUE
, max_retries => 0
, retry_delay => 0
, retention_time => 1209600
, dependency_tracking => FALSE
, comment => 'Test Object Type Queue'
, auto_commit => FALSE
);
-- ----------------------------------------------------
DBMS_AQADM.START_QUEUE ('msg_queue');
-- ----------------------------------------------------
END;
Can anybody help me out how to solve the issue
Regards
Mani