Update DML handler
The next step is to set up the Update DML
Handler using the following statement:
-- To set up the DML Handler
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER(
object_name => 'ny4.allinsured1',
object_type => 'TABLE',
operation_name => 'UPDATE',
error_handler => false,
user_procedure =>
'ny4.write_upd_lcrs',
apply_database_link => NULL,
apply_name => NULL);
END;
/
To verify the Apply handlers, execute the
SQL below:
SELECT OBJECT_OWNER, OBJECT_NAME,
OPERATION_NAME, USER_PROCEDURE
FROM DBA_APPLY_DML_HANDLERS ORDER BY
OBJECT_OWNER, OBJECT_NAME
/
