In this post, you’ll learn more about the Oracle ErrorORA-25212: invalid PRIORITY specified when using sequence deviation with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-25212: invalid PRIORITY specified when using sequence deviation
Reason for the Error ORA-25212: invalid PRIORITY specified when using sequence deviation
The PRIORITY specified in the enqueue is less than the priority of the message with the given relative message id.
How to fix the Error ORA-25212: invalid PRIORITY specified when using sequence deviation ?
You can fix this error in Oracle by following the below steps
Set the PRIORITY to be less than the delay of the message with the given relative message id. If the TOP option is used the prioirty must be greater than or equal to the priority of all the messages in the queue.