14 Replies Latest reply: Feb 7, 2013 6:44 AM by Mani RSS

    Issues occurred while creating DataBase Queue for AQ adapter in SOA

    Mani
      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