Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dequeue not yet committed message

Dmitrii DunaevAug 22 2019 — edited Aug 22 2019

Hello everyone, we use Oracle 11.2.

Lets say I enqueue 100 messages in my session. There is a single user column in the queue table that holds unique keys. Now I want to dequeue a single message with a specific key, but I want to dequeue only the one that my sessions enqueued and not yet committed, I do not want to dequeue any messages inserted by any other sessions. In other words I just want to rollback a single message and commit the other 99. How do I do that?

Thank you in advance.

Comments

i've logged a bug, thanks for your test case!

1 - 1

Post Details

Added on Aug 22 2019
3 comments
305 views