Oracle Error ORA-24018: STOP_QUEUE on string failed, outstanding transactions found

Oracle Error Message

ORA-24018: STOP_QUEUE on string failed, outstanding transactions found

Reason for the Error

There were outstanding transactions on the queue, and WAIT was set to false, so STOP_QUEUE was unsucessful in stopping the queue.

Solution

Set WAIT to TRUE and try STOP_QUEUE again. It will hang till all outstanding transactions are completed.