02300-02350: Object Extensions to SQL Messages

ORA-02300: invalid value for OIDGENERATORS

Cause: A number was not specified for the value of OIDGENERATORS.

Action: Specify a number after OIDGENERATORS.

ORA-02301: maximum number of OIDGENERATORS is 255

Cause: A number greater than 255 was specified for the value of OIDGENERATORS.

Action: Make sure the number specified for OIDGENERATORS does not exceed 255.

ORA-02302: invalid or missing type name

Cause: An invalid or missing type name was entered in a statement.

Action: Enter a valid type name in the statement and retry the operation.

ORA-02303: cannot drop or replace a type with type or table dependent(s)

Cause: An attempt was made to drop or replace a type that has dependents.

Action: Drop all type(s) and table(s) depending on the type, then retry the operation or use the FORCE option.

ORA-02304: invalid object identifier literal

Cause: An attempt was made to enter an object identifier literal for CREATE TYPE that is either:

• not a string of 32 hexadecimal characters
• an object identifier that already identifies an existing object
• an object identifier different from the original object identifier already assigned to the type

Action: Do not specify the object identifier clause or specify a 32 hexadecimal-character object identifier literal that is unique or identical to the originally assigned object identifier. Then retry the operation.

ORA-02305: only EXECUTE privilege is valid for types

Cause: An attempt was made to GRANT or REVOKE an invalid privilege (not EXECUTE) on a type.

Action: GRANT or REVOKE only the EXECUTE privilege on types.

ORA-02306: cannot create a type that already has valid dependent(s)

Cause: An attempt was made to create a type that already has some valid dependent(s) (these dependents depend on the fact that the type does not exist).

Action: Drop the dependents first before creating the type, or do not create the type.

ORA-02307: cannot ALTER with REPLACE option a type that is not valid

Cause: An attempt was made to ALTER with REPLACE option a type that is not valid.

Action: Use the CREATE OR REPLACE TYPE command to modify the type.

ORA-02308: invalid option name for object type column

Cause: An attempt was made to specify an invalid option, such as PACKED or UNPACKED, for the object type column.

Action: Remove the invalid option from column specification and retry the operation.

ORA-02309: atomic NULL violation

Cause: An attempt was made to access the attributes of a NULL object instance.

Action: Ensure that the object instance is non-NULL before accessing.

ORA-02310: exceeded maximum number of allowable columns in table

Cause: The attributes in the object type column exceeded the maximum number of columns allowed in a table.

Action: Specify fewer attributes for the object type and retry the operation.

ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents"

Cause: An attempt was made to ALTER with COMPILE option a type that is valid and has type or table dependents.

Action: No need to perform this operation.

ORA-02312: cannot create extent table for VALUE ADT

Cause: An attempt was made to create extent table for VALUE Object Type.

Action: Specify object type when creating extent table.

ORA-02313: object type contains non-queryable type name attribute

Cause: The specified object type contains a nested attribute whose type is non-queryable.

Action: Use an object type with queryable attribute types.

ORA-02315: incorrect number of arguments for default constructor

Cause: The number of arguments specified for the default constructor does not match the number of attributes of the object type.

Action: Specify the correct number of arguments for the default constructor and retry the operation.

ORA-02320: failure in creating storage table for nested table column name

Cause: An error occurred while creating the storage table for the specified nested table column.

Action: See the messages that follow for more details. If the situation they describe can be corrected, do so; otherwise contact Oracle Support.

ORA-02322: failure in accessing storage table of the nested table column

Cause: An error occured while performing DML on the storage table of the nested table column.

Action: If the situation described in the following messages can be corrected, do so; otherwise contact Oracle Support.

ORA-02324: more than one column in the SELECT list of the THE subquery

Cause: More than one column was selected in the THE subquery.

Action: Specify only one column in the SELECT list of the THE subquery and retry the operation.

ORA-02327: cannot create index on column with datatype name

Cause: An attempt was made to create an index on a non-indexable column.

Action: Change the column datatype or do not create the index on a column whose datatype is one of VARRAY, nested table, object, LOB, or REF.

ORA-02329: column of datatype name cannot be unique or a primary key

Cause: An attempt was made to place a UNIQUE or a PRIMARY KEY constraint on a column of datatype VARRAY, nested table, object, LOB, FILE or REF.

Action: Change the column datatype or remove the constraint. Then retry the operation.

ORA-02330: datatype specification not allowed

Cause: An attempt was made to specify the data type in the column constraint specification of an object table.

Action: Remove data type specification and retry the operation.

ORA-02331: cannot create constraint on column of datatype name

Cause: An attempt was made to create a constraint on a column posessing a non-constrainable datatype -- VARRAY, nested table, object, LOB, FILE, or REF.

Action: Change the column datatype, or remove the constraint.

ORA-02332: cannot create index on attributes of this column

Cause: An attempt was made to create an index on an attributes of an object type column.

Action: Do not specify the index on the attribute.

ORA-02333: cannot create constraints on attributes of this column

Cause: An attempt was made to create a constraint on an attribute of an object type column.

Action: Remove the constraint or change the object type.

ORA-02334: cannot infer type for column

Cause: A datatype was not declared for this column (in the CREATE TABLE) and an attempt was made to create a constraint on an attribute of this column.

Action: Declare a datatype for the column.

ORA-02335: invalid datatype for CLUSTER column

Cause: An attempt was made to declare a CLUSTER column of datatype object, REF, nested table, VARRAY, LOB, or FILE.

Action: Remove the CLUSTER column or change the datatype of the column.

ORA-02336: column attribute cannot be accessed

Cause: An attempt was made to extract an attribute of an object type column.

Action: Change the object type for the column and retry the operation.

ORA-02337: not an object type column

Cause: An attempt was made to use dotted notation on a non-object type column; that is, "a.b.c" where "a" is not an object type.

Action: Either change the column type to an object type or do not perform this operation.

ORA-02338: missing or invalid column constraint specification

Cause: A column constraint was not specified.

Action: Remove the column specification or specify a column constraint. Then retry the operation.

ORA-02339: invalid column specification

Cause: An attempt was made to specify the PACKED or UNPACKED keyword for a non-object type column.

Action: Remove the PACKED or UNPACKED keyword in the column specification and retry the operation.

ORA-02340: invalid column specification

Cause: An attempt was made to specify an UNPACKED column within a packed table.

Action: Remove the UNPACKED keyword in the column specification.

ORA-02341: cannot refer to non-queryable type name in SQL

Cause: Attempt to refer to an object type attribute that is of a non-queryable type in SQL.

Action: Change attribute type to a SQL-queryable type, or reference the attribute through a 3GL.

ORA-02342: replacement type causes compilation error

Cause: The use of the ALTER...REPLACE statement on a valid type caused a compilation error.

Action: Use the ALTER...REPLACE statement to replace the type with a valid type which does not cause compilation errors.

ORA-02343: CASCADE aborted, type(s) have dependent(s) in other schemas

Cause: An attempt was made to cascade drop a user whose type(s) have dependent(s) in other schemas.

Action: The dependent(s) in the other schema must first be dropped before the user can be dropped.

ORA-02344: cannot revoke execute on a type with table dependents

Cause: An attempt was made to revoke execute on a type that has dependents.

Action: Drop all table(s) depending on the type, then retry the operation, or use the FORCE option.

ORA-02345: cannot create a view with column based on CURSOR operator

Cause: A CURSOR operator was used as one of the SELECT elements in the subquery of a CREATE VIEW or CREATE TABLE ... AS SELECT statement.

Action: Remove the CURSOR operator and replace it with the CAST operator.

ORA-02347: cannot grant privileges on columns of an object table

Cause: An attempt was made to grant privileges on the columns of an object table.

Action: Choose another table. Privileges cannot be granted on columns of an object table.

ORA-02349: invalid user-defined type - type is incomplete

Cause: An attempt was made to use an incomplete type definition as a column or table datatype.

Action: Complete the type definition and retry the operation.

---