GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

AQ subscriber/handler question

edited May 12, 2011 11:28PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered
I know that if you have an explicit call to DBMS_AQ.DEQUEUEm you need to perform a COMMIT to remove the item from the queue.

Is this also true in the case of a registered callback procedure?  I have the scenario where if in my handler, I have some processing error

from other DML, I want to do a rollback, but also want the processed message removed from the queue.  The the message already

removed from the queue when the handler is called, or does the handler have to do a commit, and if so, how to rollback other DML in the handler?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center