Oracle Solution for Error ora-24011
ORA-24011: cannot drop QUEUE, string should be stopped first
What triggered the Error:
e queue has not been stopped i.e. either enqueue or dequeue is still enabled.What should we do to fix it:
op the queue first using the STOP_QUEUE command and disable it from both enqueueing and dequeueing.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
