I'm using Oracle Advance Queuing mechanism.
I'm dequeuing msg from a queue, and after checking it I, sometimes,
want to rollback changes but move msg to exception queue.
I cant just rollback dequeue, browse msg and rollback until it goes to
exception queue because I have multiple consumers (they dont share
messages between them, any message is enqueued just by one consumer)
and when I roll it back other consumers may 'take over it'.
does any one have any solution to this problem?
Sent via Deja.com http://www.deja.com/
Before you buy.