Hi Tom,

Hope you had a good timeoff and not sure whether this is a silly question to ask. I did try searching on the Oracle forum but did not get any conclusive details on the wait option to be set as true or false while stopping the Oracle queue.

We have a issue in our system wherein the Java MDB server are getting stopped every 2 hours and in case any queue transaction is dequeued and in progress, a protocol violation error is raised and it is not processed further. To avoid this issue , we are looking at stopping the dequeue before restarting the server and then start the dequeue again once the server has been restarted successfully so that we don't miss out on any transactions.

Below was the command, we had used to stop the dequeuing. Even though we had around 20 plus transactions to be dequeued, system still allowed to stop the queue but the comments on oracle forum says otherwise

Wait :- Specifies whether to wait for the completion of outstanding transactions. TRUE means wait if there are any outstanding transactions. In this state no new transactions are allowed to enqueue to or dequeue from this queue. FALSE means return immediately either with a success or an error.

begin
DBMS_AQADM.STOP_QUEUE (   
   'TEST_2023_Q',
   FALSE,
   TRUE,
   TRUE);
end;

Could you please advise if there is anything wrong in my understanding or the piece of code