ORA-25237: navigation option used out of sequence
What triggered the Error:
e NEXT_MESSAGE or NEXT_TRANSACTION option was specified after dequeuing all the messages.What should we do to fix it:
set the dequeuing position using the FIRST_MESSAGE naviagtion option and then specify the NEXT_MESSAGE or NEXT_TRANSACTION option.