Oracle Error Message
ORA-25237: navigation option used out of sequence
Reason for the Error
The NEXT_MESSAGE or NEXT_TRANSACTION option was specified after dequeuing all the messages.
Solution
Reset the dequeuing position using the FIRST_MESSAGE naviagtion option and then specify the NEXT_MESSAGE or NEXT_TRANSACTION option.