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 184.108.40.206 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 220.127.116.11 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
Million Knowledge Articles and hundreds of Community platforms