ORA-25292: Buffer operations are not supported on the queue
Cause: Buffer operations are not supported on the specified queue type
Action: Buffered operations are only supported on to 8.1 style queues, which do not have transaction grouping.
。
QUEUE_TABLE.ENQUEUE(nvl(:BUFFERED(PAYLOAD_BLOB_VAR)
1、定位故障程序,查找具体产生错误的接口,函数等等不扩展函数。
2、查看数据库相关参数,查看是否有异常数据或脏数据造成Unsupported Buffer function。
3、查看服务器、网络状态,确保网络带宽状况正常;
4、查看表空间、Tablespace 是否已满,确保有足够的容量;
5、尝试重新启动数据库,重置对应的帐号。