22800-22849: Object SQL Messages

ORA-22800: invalid user-defined type

Cause: An attempt was made to use an incomplete type as a constructor.

Action: Complete the type definition before using it in a query.

ORA-22801: invalid object row variable

Cause: The specified object row variable is not available in the scope of name resolution.

Action: Verify the specified row object variable is correct, or use a valid row object variable visible in scope.

ORA-22803: object type contains zero attributes

Cause: An attempt was made to create or specify a column or constructor of an object type that has no attributes. Only object types that have at least one attribute are allowed in this context.

Action: Specify a valid object type and retry the operation.

ORA-22804: remote operations not permitted on object tables or user-defined type columns

Cause: An attempt was made to perform queries or DML operations on remote object tables or on remote table columns whose type is one of object, REF, nested table or VARRAY.

Action: Remove the reference to remote tables in the statement.

ORA-22805: cannot insert NULL object into object tables or nested tables

Cause: An attempt was made to insert a NULL object into an object table or a Nested Table.

Action: Ensure that a non-NULL object is inserted into the table or insert an object with attributes whose values are NULL.

ORA-22806: not an object or REF

Cause: An attempt was made to extract an attribute from an item that is neither an object nor a REF.

Action: Use an object type or REF type item and retry the operation.

ORA-22807: cannot resolve to a scalar or a collection type

Cause: Invalid use of a non-scalar (for example, object type) item.

Action: Change the item's data type and retry the operation.

ORA-22808: REF dereferencing not allowed

Cause: An attempt was made to access a type's attributes by dereferencing a REF item.

Action: Make the item an object type instead of a REF to an object type.

ORA-22809: nonexistent attribute

Cause: An attempt was made to access a non-existent attribute of an object type.

Action: Check the attribute reference to see if it is valid. Then retry the operation.

ORA-22810: cannot modify object attributes with REF dereferencing

Cause: An attempt was made to modify attributes of an object by dereferencing a REF column in an UPDATE statement.

Action: Update the table containing the object that the REF points to, or change the REF column to an object type column.

ORA-22812: cannot reference NESTED TABLE column's storage table

Cause: An attempt to access the nested table column's storage table is not allowed in the given context.

Action: Issue the statement against the parent table containing the NESTED TABLE column.

ORA-22813: operand value exceeds system limits

Cause: Object or Collection value was too large. The size of the value might have exceeded 30k in a SORT context, or the size may be too big for available memory.

Action: Choose another value and retry the operation.

ORA-22814: attribute or element value is larger than declared in type

Cause: Value provided for the object type attribute or collection element exceeded the size specified in the type declaration.

Action: Choose another value and retry the operation.

ORA-22816: unsupported feature with RETURNING clause

Cause: RETURNING clause is currently not supported for object type columns, LONG columns, remote tables and INSERT with subquery.

Action: Use separate SELECT statement to get the values.

---