22880-22899: Object SQL REF/DEREF Support Messages

ORA-22880: invalid REF

Cause: An invalid REF was accessed.

Action: Modify the REF and retry the operation.

ORA-22881: dangling REF

Cause: The object corresponding to the REF that was accessed does not exist.

Action: Ensure that the REF value is pointing to an existing object.

ORA-22882: object creation failed

Cause: The object cannot be inserted in the database.

Action: Check to see if the object table exists and that the object size is not too big. Then retry the operation.

ORA-22883: object deletion failed

Cause: The object could not be deleted from the database.

Action: Check to see if the table exists. Then retry the operation.

ORA-22884: object modification failed

Cause: The object could not be modified in the database.

Action: Check to see if the object table exists and the object size is not too big. Then retry the operation.

ORA-22885: cannot get REF to a non-persistent object

Cause: An attempt was made to get a REF for something other than an object in an object table. REFs can only be taken for objects in object tables.

Action: Rewrite the query to obtain REF values from object tables.

ORA-22886: scoped table name in schema name is not an object table

Cause: The scoped table specified for a REF column is not an object table.

Action: Ensure that the scope table is an object table. Then retry the operation.

ORA-22887: type of REF column is not the same as that of its scoped table

Cause: The type specified for the REF column and the type specified for the scoped table are different.

Action: Ensure that the types of a REF column and its scoped table are the same.

ORA-22888: duplicate SCOPE clauses for a REF column

Cause: Multiple SCOPE clauses were specified for a single REF column.

Action: Remove the duplicate scope clauses and retry the operation.

ORA-22889: REF value does not point to scoped table

Cause: An attempt was made to insert a REF value that does not point to the scoped table.

Action: Ensure that the REF values point to the scoped table.

ORA-22890: cannot specify name for REF column constraint

Cause: An attempt was made to specify a constraint name for a constraint on a REF column.

Action: Remove the constraint name and retry the operation.

ORA-22891: cannot have multiple columns in REF constraint

Cause: An attempt was made to specify multiple columns in a single REF constraint.

Action: Specify separate constraints for each column and retry the operation.

ORA-22892: scoped table name does not exist in schema name

Cause: The scope table specified for a REF column does not exist.

Action: Ensure that the scope table exists and retry the operation.

ORA-22893: constraint can be specified only for REF columns

Cause: The constraint specified does not apply to non-REF columns.

Action: Remove the constraint.

ORA-22894: cannot add constraint on existing REF columns of non-empty tables

Cause: An attempt was made to add a constraint to existing REF columns of a table which contains one or more rows.

Action: Remove the constraint specification or add the constraint after emptying the table.

---