ss

ORA-23607 Invalid Column

• Rename a column that does not exist in the row LCR.

ORA-24031 Invalid Value, parameter_name, Should Be Non-NULL

This error may occur when an Apply handler or a rule-based transformation passes a NULL value to an LCR member subprogram instead of a SYS.AnyData value that contains a NULL.

For example, the following call to the add_column member procedure for row LCRs may result in the specified error:

new_lcr.ADD_COLUMN('OLD','SALES_ID',NULL);

The following SQL shows the correct way to call the add_column member procedure for row LCRs:

new_lcr.ADD_COLUMN('OLD','SALES_ID',SYS.AnyData.ConvertVarchar2(NULL));

ORA-26687 Instantiation SCN Not Set

This error occurs because the instantiation SCN is not set on an object for which an Apply process is attempting to apply changes. The dba_apply_instantiated_objects data dictionary view can be queried to list the objects that have an instantiation SCN.

ORA-26688 Missing Key in LCR

Generally speaking, this error occurs because of one of the following conditions: