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

Last updated on MAY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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>"




DECLARE
dequeue_options DBMS_AQ.dequeue_options_t;
message_properties DBMS_AQ.message_properties_t;
message_handle RAW(16);
mes <message type>;
BEGIN
dequeue_options.wait := DBMS_AQ.NO_WAIT;
dequeue_options.navigation := DBMS_AQ.FIRST_MESSAGE;
dequeue_options.msgid := '91CCFEAA83B263F1E040A8C025FD3D24';
DBMS_AQ.DEQUEUE(
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




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms