This content has been marked as final. Show 3 replies
A DML handler is used to replace the normal Streams apply processing with a customized procedure or a SQL statement (in the case of Statement handlers). If you configure a DML handler, you should handle any errors that might occur within the DML handler.
Error handlers can coexist with Statement handlers, but can not coexist with procedural DML handlers.
Typically Error handlers are used to handle errors that occur using the normal Streams apply processing.
I too have a similar requirement. Could anyone help with one?
We can handle the error-ing transactions via Error Handler procedures.
But we can not configure the DML handler procedure for transactions that are successfully replicated. STreams does not allow us to configure a handler for this. Is there any other handler / procedures / hooks in streams where we can implement the desired functionality - which includes changing the values in the LCR before invoking lcr.execute() and we should be able to discard the LCR also if required.
Edited by: 982387 on Jan 16, 2013 11:25 PM
Edited by: 982387 on Jan 16, 2013 11:27 PM