I have created an queue in oracle 11g with multiple subscribers. I have registered the subscribers with following script
aSubscriber := sys.AQ$_AGENT ('CUST_SUBSCRIBER', null, null);
DBMS_AQADM.add_subscriber (queue_name => 'RT_REP.QUEUE_SBCUSTOMER',
subscriber => aSubscriber);
But it seems the dequeue is not working. All the grants / permissions are fine but still not dequeue.
Any pointers please.
Not sure this is the [only] reason, but you didn't specify the payload type for the PL/SQL callback. Your callback specification should be either 'plsql://SPIN_D.dequeue_messages.dequeuecust?PR=0' for raw payload or 'plsql://SPIN_D.dequeue_messages.dequeuecust?PR=1' for ADT payload encoded in XML. Also, your AQ$_REG_INFO.NAME attribute is missing queue schema name.