Home » Server Options » Streams & AQ » DML handler (oracle 10g)
DML handler [message #483645] Tue, 23 November 2010 16:33
Messages: 2
Registered: August 2008
Junior Member
We are using oracle 10g Bi-directional streams and facing one problem in the batch job which runs everynight on both the databases. Due to the bug in code we get an apply error on both the databases at the same time. The statment which runs on both sides is delete. This is a third party code which we are running in our system and they will provide us the fix not soon. For now we need to temporarily fix this issue so that we can't get this error and handler will take care of this and delete it automatically when it shows up.

Can someone tell us how to write a DML handler for this particular case so that only those apply error will deleted for a that table and nothing else. I also like to add that in live traffic there are delete happens on this table. So, in this case we only create a handler which detects this error and remove those apply errors.

Thanks in advance.
Previous Topic: Supplemental logs
Goto Forum:

Current Time: Tue Mar 28 22:26:49 CDT 2023