Oracle Error ORA-24011: cannot drop QUEUE, string should be stopped first

Oracle Error Message

ORA-24011: cannot drop QUEUE, string should be stopped first

Reason for the Error

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

Solution

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