Dequeue By Msgid Of Message After Rollback And Within Retry Delay Period : Ora-25228 Returned (Doc ID 1363087.1)

Last updated on MAY 15, 2017

Applies to:

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

Symptoms

When Message retry delay has been specified and a dequeue attempt is made on a message
which is then rolled back, it is observed that the message cannot then be dequeued by message id
within the retry delay period.  ORA-25228 is returned.

The state of the message is READY following the above .

This is a change in behaviour to what was observed in earlier releases : 10.2.0.5 and 11.1.0.7 where it was possible to dequeue the message during the retry delay period.

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