How to fix the Oracle error ORA-25299: Invalid message delivery_mode?

In this post, you’ll learn more about the Oracle ErrorORA-25299: Invalid message delivery_mode with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-25299: Invalid message delivery_mode

Reason for the Error ORA-25299: Invalid message delivery_mode

Invalid value was specified for delivery mode

How to fix the Error ORA-25299: Invalid message delivery_mode ?

You can fix this error in Oracle by following the below steps

Specify dbms_aq.BUFFERED or dbms_aq.PERSISTENT during Enqueue or dbms_aq.BUFFERED, dbms_aq.PERSISTENT or dbms_aq.PERSISTENT_OR_BUFFERED during Dequeue and Listen.