My Oracle Support Banner

ORA-25263 Returned While Dequeueing a Message From AQ Using DBMS_AQ.NO_WAIT option (Doc ID 1344845.1)

Last updated on DECEMBER 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


A dequeue procedure , like the one below , attempting to dequeue using Message ID fails with

ORA-25263, 00000, "no message in queue <queue name> with message ID <msgid>"

dequeue_options DBMS_AQ.dequeue_options_t;
message_properties DBMS_AQ.message_properties_t;
message_handle RAW(16);
mes <message type>;
dequeue_options.wait := DBMS_AQ.NO_WAIT;
dequeue_options.navigation := DBMS_AQ.FIRST_MESSAGE;
dequeue_options.msgid := '91CCFEAA83B263F1E040A8C025FD3D24';
queue_name => '<queue_name>',
dequeue_options => dequeue_options,
message_properties => message_properties,
payload => mes,
msgid => message_handle);

The message  is present in the queue table and the state is "READY".

A Sql trace of the dequeue session shows the following errors

ERROR #8:err=54 tim=3155033646
EXEC #5:c=11999,e=12017,p=0,cr=190,cu=1,mis=0,r=0,dep=0,og=1,tim=1281521167301061
ERROR #5:err=25263 tim=3155033646


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.