Oracle Solution for Error ora-24018

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

What triggered the Error:

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

What should we do to fix it:

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