Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issues occurred while creating DataBase Queue for AQ adapter in SOA

ManiFeb 5 2013 — edited Feb 7 2013
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2013
Added on Feb 5 2013
14 comments
955 views