Oracle Error ORA-25233: invalid parameter specified for NAVIGATION

Oracle Error Message

ORA-25233: invalid parameter specified for NAVIGATION

Reason for the Error

An invalid parameter has been specified for NAVIGATION.

Solution

Choose one of FIRST_MESSAGE, NEXT_MESSAGE or NEXT_TRANSACTION. Use FIRST_MESSAGE for dequeuing the first message that satisifies the criterion, NEXT_MESSAGE for dequeuing the next message that satisifies the criterion and NEXT_TRANSACTION for moving to a set of messages enqueued by another transaction.