Home » Server Options » Streams & AQ » DEQUEUE Option (10204)
DEQUEUE Option [message #556166] Thu, 31 May 2012 12:06
bella13
Messages: 90
Registered: July 2005
Member
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: Wed Oct 22 17:26:57 CDT 2014

Total time taken to generate the page: 0.08560 seconds