Oracle in a Nutshell

Calls

PROCEDURE DBMS_APPLY_ADM.ALTER_APPLY (apply_name IN VARCHAR2, rule_set_name IN VARCHAR2 DEFAULT NULL, remove_rule_set IN BOOLEAN DEFAULT FALSE, message_handler IN VARCHAR2 DEFAULT NULL, remove_message handler IN BOOLEAN DEFAULT FALSE, ddl_handler IN VARCHAR2 DEFAULT NULL, remove_ddl_handler IN BOOLEAN DEFAULT FALSE, apply_user IN VARCHAR2 DEFAULT NULL, apply_tag IN RAW DEFAULT NULL, remove_apply_tag IN BOOLEAN DEFAULT FALSE);

Alters the characteristics of an apply process by changing or canceling the rule set, message handler, DDL handler, or tag or changes the user who applies all DML and DDL changes and runs apply handlers. The apply process is stopped and restarted when you change any of the characteristics except the user.

PROCEDURE DBMS_APPLY_ADM.CREATE_APPLY (queue_name IN VARCHAR2, apply_name IN VARCHAR2, rule_set_name IN VARCHAR2 DEFAULT NULL, message_handler IN VARCHAR2 DEFAULT NULL, ddl_handle IN VARCHAR2 DEFAULT NULL, apply_user IN VARCHAR2 DEFAULT NULL, apply_database_link IN VARCHAR2 DEFAULT NULL, apply_tag IN RAW DEFAULT '00', apply_captured IN BOOLEAN DEFAULT FALSE);

Creates an apply process.

PROCEDURE DBMS_APPLY_ADM.DELETE_ALL_ERRORS (apply_name IN VARCHAR2 DEFAULT NULL);

Deletes all error transactions for the specified apply process.

PROCEDURE DBMS_APPLY_ADM.DELETE_ERROR (local_transaction_id IN VARCHAR2);

Deletes a specific error transaction.

PROCEDURE DBMS_APPLY_ADM.DROP_APPLY (apply_name IN VARCHAR2);

Drops the specified apply process.

PROCEDURE DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS ...