Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page