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.