Update DML handler
Table
Owner Table Name Operation Handler
Procedure
-------- ---------- -----------
---------------------
NY4 ALLINSURED1 UPDATE
"NY4"."WRITE_UPD_LCRS"
NY4 ALLINSURED1
DELETE "NY4"."WRITE_DEL_LCRS"
To unset the DML handler, set the
user_procedure parameter to NULL. For example, use the
following SQL Statement to unset the apply handler:
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER(
object_name => 'ny4.allinsured1',
object_type => 'TABLE',
operation_name => 'UPDATE',
error_handler => false,
user_procedure
=> NULL ,
apply_database_link
=> NULL,
apply_name => NULL);
END;
/