OBJECT_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object on which the DML handler is specified |
OBJECT_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object on which the DML handler is specified |
OPERATION_NAME |
VARCHAR2(13) |
|
Name of the DML operation for which the DML handler is used:
-
DEFAULT
-
INSERT
-
UPDATE
-
DELETE
-
LOB_UPDATE
-
ASSEMBLE_LOBS
|
USER_PROCEDURE |
VARCHAR2(98) |
|
Name of the user-specified DML handler, which handles row logical change records that contain the DML operation in the OPERATION_NAME column on the object |
ERROR_HANDLER |
VARCHAR2(1) |
|
Indicates whether the DML handler handles only the relevant row logical change records that result in apply errors (Y) or all relevant row logical change records (N) |
APPLY_DATABASE_LINK |
VARCHAR2(128) |
|
Database link to which changes are applied. If null, then changes are applied to the local database. |
APPLY_NAME |
VARCHAR2(30) |
|
Name of the apply process for the given object |
ASSEMBLE_LOBS |
VARCHAR2(1) |
|
Indicates whether LOB assembly is used for LOB columns in logical change records (LCRs) processed by the handler (Y) or not (N)
LOB assembly combines multiple LCRs for a LOB column resulting from a single row change into one row LCR before passing the LCR to the handler.
|
HANDLER_NAME |
VARCHAR2(30) |
|
Name of the apply DML handler; NULL for error and procedural handlers |
HANDLER_TYPE |
VARCHAR2(17) |
|
Type of the apply DML handler:
-
STMT HANDLER
-
ERROR HANDLER
-
PROCEDURE HANDLER
|
