Hi,
I have two different queues with 2 different QUEUE_TABLES. On each queue is registered a callback function with DBMS_AQADM.ADD_SUBSCRIBER. After I'm calling dbms_aq.enqueue for the corresponding queue both callbacks are firing as expected.
Following problem: The callback for the first queue is a long running procedure (about 4 hrs). During this 4 hrs the callback for the second queue is not firing-> I see only the enqueue call in the second queue, but not dequeue. Immediately after the first callback is finished I see the dequeue call for the second queue.
Can someone provide an example for parallel firing callbacks?
Many thanks in advance and regards
Alexander