Logical Change Record Types, 6 of 6

LCR$_ROW_UNIT Type

Identifies the value for a column in a row.

This type is used in the LCR$_ROW_LIST type.

See Also:

Syntax

CREATE TYPE LCR$_ROW_UNIT AS OBJECT (
  column_name         VARCHAR2(4000),
  data                SYS.AnyData,
  lob_information     NUMBER,
  lob_offset          NUMBER,
  lob_operation_size  NUMBER);
/

Attributes

Table 108-32 LCR$_ROW_UNIT Attributes

Attribute	Description
`column_name`	The name of the column
`data`	The data contained in the column
`lob_information`	Contains the LOB information for the column and contains one of the following values: DBMS_LCR.NOT_A_LOB CONSTANT NUMBER := 1; DBMS_LCR.NULL_LOB CONSTANT NUMBER := 2; DBMS_LCR.INLINE_LOB CONSTANT NUMBER := 3; DBMS_LCR.EMPTY_LOB CONSTANT NUMBER := 4; DBMS_LCR.LOB_CHUNK CONSTANT NUMBER := 5; DBMS_LCR.LAST_LOB_CHUNK CONSTANT NUMBER := 6;
`lob_offset`	The LOB offset specified in the number of characters for `CLOB` columns and the number of bytes for `BLOB` columns. Valid values are `NULL` or a positive integer less than or equal to `DBMS_LOB.LOBMAXSIZE`.
`lob_operation_size`	If `lob_information` for the LOB is `DBMS_LCR.LAST_LOB_CHUNK`, then can be set to either a valid `LOB` `ERASE` value or a valid `LOB` `TRIM` value. A `LOB_ERASE` value must be a positive integer less than or equal to `DBMS_LOB.LOBMAXSIZE`. A `LOB_TRIM` value must be a nonnegative integer less than or equal to `DBMS_LOB.LOBMAXSIZE`. If `lob_information` is not `DBMS_LCR.LAST_LOB_CHUNK` and for all other operations, is `NULL`.