This chapter describes the XStream functions for OCI.
A row logical change record (LCR) is used to encapsulate each row change. It includes the schema name, table name, DML operation, and the column values. For update operations, both before and after column values are included. The column data is in the format specified by the "Program Variable" column in Table 27-3. Character columns are converted to the client's character set.
A DDL LCR is used to encapsulate each DDL change. It includes the object name, the DDL text, and the DDL command, for example,
TABLE. See Table A-1 for a list of DDL command codes.
Oracle Database Globalization Support Guide for more information about NLS settings.
XStream sample programs are found in
xstream/oci under the
Each LCR also has a transaction ID and position. For transactions captured outside Oracle databases, any byte-comparable
RAW array can be used as the LCR position, if the position of each LCR in the stream is strictly increasing.
This chapter contains the topic: