| 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,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
