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 and later
Information in this document applies to any platform.


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 : and where it was possible to dequeue the message during the retry delay period.


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