How to fix the Oracle error ORA-25298: Only immediate visibility mode supported for buffered message enqueue or dequeue?

In this post, you’ll learn more about the Oracle ErrorORA-25298: Only immediate visibility mode supported for buffered message enqueue or dequeue with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-25298: Only immediate visibility mode supported for buffered message enqueue or dequeue

Reason for the Error ORA-25298: Only immediate visibility mode supported for buffered message enqueue or dequeue

A visibility of dbms_aq.ON_COMMIT was supplied with the buffered message enqueue or dequeue

How to fix the Error ORA-25298: Only immediate visibility mode supported for buffered message enqueue or dequeue ?

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

Supply a visibility of dbms_aq.IMMEDIATE