Thursday, December 11, 2008

Unset streams DML handler

To unset DML handler in a streams environment, simply point "user_procedure" to NULL.

Eg.

BEGIN DBMS_APPLY_ADM.SET_DML_HANDLER(
object_name => '',
object_type => 'TABLE',
operation_name => 'INSERT',
error_handler => false,
user_procedure => NULL ,
apply_database_link => NULL,
apply_name => NULL);
END;
/

No comments: