Dequeue By Msgid Of Message After Rollback And Within Retry Delay Period : Ora-25228 Returned
Last updated on MAY 15, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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 : 10.2.0.5 and 184.108.40.206 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