Home » Server Options » Streams & AQ » DEQUEUE Option (10204)
DEQUEUE Option [message #556166] Thu, 31 May 2012 12:06
Messages: 90
Registered: July 2005
I have 4 queue tables, and I want to DEQUEUE all the messages in the queue.

can I call DBMS_AQ.DEQUEUE in a loop. How can i provide each thread that it needs to dequeue by looping through all the queues, and then dequeing all its messages.

DBMS_AQ.DEQUEUE(queue_name => queue_name ,
dequeue_options => queue_options,
message_properties => message_properties,
payload => message,msgid => message_id );
thanks in advance,

Previous Topic: how to deal with my problem
Next Topic: Data Clean up in Persistent Queue
Goto Forum:

Current Time: Thu May 23 19:40:15 CDT 2024