3 Replies Latest reply: Oct 7, 2010 2:11 PM by Vladimir Zakharychev RSS

    Oracle 11g - Advanced Queue

    117646
      I have created an queue in oracle 11g with multiple subscribers. I have registered the subscribers with following script

      DECLARE
      aSubscriber SYS.AQ$_AGENT;
      BEGIN
      aSubscriber := sys.AQ$_AGENT ('CUST_SUBSCRIBER', null, null);

      DBMS_AQADM.add_subscriber (queue_name => 'RT_REP.QUEUE_SBCUSTOMER',
      subscriber => aSubscriber);
      DBMS_AQ.REGISTER (
      SYS.AQ$_REG_INFO_LIST(SYS.AQ$_REG_INFO (
      'QUEUE_SBCUSTOMER:CUST_SUBSCRIBER',
      DBMS_AQ.NAMESPACE_AQ,
      'plsql://SPIN_D.dequeue_messages.dequeuecust',
      HEXTORAW ('FF'))),
      1);
      END;

      But it seems the dequeue is not working. All the grants / permissions are fine but still not dequeue.

      Any pointers please.

      Regards,
      Nilesh