Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-24011 – cannot drop QUEUE, string should be stopped first

Oracle Database Error Code ORA-24011 Description :

cannot drop QUEUE, string should be stopped first

Error Cause:

The queue has not been stopped i.e. either enqueue or dequeue is still enabled.

How to Solve :

Stop the queue first using the STOP_QUEUE command and disable it from both enqueueing and dequeueing.