ORA-22613: buflen does not match the size of the scalar

ORA-22613: buflen does not match the size of the scalar

Cause: buflen is incorrect

Action: Make sure buflen is correct and matches the size of the scalar

ORA-22612: TDS does not describe a collection TDS

ORA-22612: TDS does not describe a collection TDS

Cause: collection construct or access routines are being on an image but the TDS does not describe that a collection TDS

Action: Make sure a collection TDS is used before invoking collection routines on the image handle

ORA-22611: TDS version is not recognized

ORA-22611: TDS version is not recognized

Cause: Incorrect TDS handle is passed

Action: Make sure image handle is initialized with the correct TDS

ORA-22610: error while adding a scalar to the image handle

ORA-22610: error while adding a scalar to the image handle

Cause: Error while adding a scalar attribute to the image handle

Action: Make sure image handle is initialized before adding scalar

ORA-22609: error string during initialization of FDO

ORA-22609: error string during initialization of FDO

Cause: Error during FDO initialization.

Action: Take an action based on the specified error.

ORA-22608: cannot add an attribute to the already generated image handle

ORA-22608: cannot add an attribute to the already generated image handle

Cause: Attempt to add an attribute to the already constructed image.

Action: Use a image handle that is initialized but not yet constructed.

ORA-22607: image handle already generated

ORA-22607: image handle already generated

Cause: Attempt to geneate image that is already genearated.

Action: Use a image handle that is initialized but not yet generated.

ORA-22606: pickler image handle (string( is not well-formed

ORA-22606: pickler image handle (string( is not well-formed

Cause: Attempt to use the image handle without initializing or constructing it.

Action: Use OCIPicklerImageInit to initialize the handle before it is constructed. Use OCIPicklerImageGenerate to generate the image before its attributes can be accessed.

ORA-22605: FDO handle (string( is not initialized

ORA-22605: FDO handle (string( is not initialized

Cause: Attempt to use an uninitialized FDO handle.

Action: Use OCIPicklerFdoInit to initialize FDO handle .

ORA-22604: TDS handle already generated

ORA-22604: TDS handle already generated

Cause: Attempt to geneate TDS that is already genearated.

Action: Use a TDS handle that is initialized but not yet generated.

ORA-22603: cannot add an attribute to the already generated TDS handle

ORA-22603: cannot add an attribute to the already generated TDS handle

Cause: Attempt to add an attribute to the already constructed TDS.

Action: Use a TDS handle that is initialized but not yet constructed.

ORA-22602: pickler TDS handle (string( is not well-formed

ORA-22602: pickler TDS handle (string( is not well-formed

Cause: Attempt to use the pickler TDS handle without initializing or constructing it.

Action: Use OCIPicklerTdsInit to initialize the handle before it is constructed. Use OCIPicklerTdsGenerate to generate the TDS before its attributes can be accessed.

ORA-22601: pickler TDS context (string( is not initialized

ORA-22601: pickler TDS context (string( is not initialized

Cause: Attempt to use the pickler TDS context without initializing it.

Action: Use OCIPicklerTdsCtxInit to initialize the context.

ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

Cause: Production Oracle8 (8.0.3 and beyond) encounters some VARRAY data which was created and stored by Oracle8 8.0.2 (Beta 2). Production Oracle8 cannot understand or process such VARRAY data.

Action: Delete the VARRAY data from the table by dropping the table, deleting the rows, or nulling out the VARRAY columns, and then re-insert the VARRAY data. There is no provided script or tool to help automate this conversion.

ORA-22371: Table contains data of type string.string, version string, which does not exist

ORA-22371: Table contains data of type string.string, version string, which does not exist

Cause: Some of the older versions of the type may have got deleted because one or more of the types it were referencing was dropped.

Action: These data could not be read as the whole ADT. Read the data at individual scalar attribute level.

ORA-22370: incorrect usage of method string

ORA-22370: incorrect usage of method string

Cause: This method of SYS.AnyType or SYS.AnyData or SYS.AnyDataSet is being used inappropriately.

Action: Check the documentation for correct usage.

ORA-22369: invalid parameter encountered in method string

ORA-22369: invalid parameter encountered in method string

Cause: An invalid parameter is being passed to this method of SYS.AnyType ,SYS.AnyData or SYS.AnyDataSet

Action: Check the parameters being passed to this method and make sure that the parameters are allowed.

ORA-22347: No changes to type specified for ALTER TYPE

ORA-22347: No changes to type specified for ALTER TYPE

Cause: The ALTER TYPE does not contain any changes to the type.

Action: If any change is required for the type, modify the ALTER TYPE to specify the change. Else no need for the ALTER.

ORA-22346: Type has cyclical dependency. Should use CASCADE option

ORA-22346: Type has cyclical dependency. Should use CASCADE option

Cause: An attempt was made to alter a type which has a cyclical dependency, with invalidate option.

Action: Give CASCADE option instead of INVALIDATE

ORA-22345: recompile type string.string before attempting this operation

ORA-22345: recompile type string.string before attempting this operation

Cause: An attempt was made to perform an operation which requires the specified datatype to be valid, but the datatype is invalid

Action: Recompile the specified type and retry the operation

ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

Cause: An attempt was made to specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change.

Action: Specify CONVERT TO SUBSTITUTABLE option only for ALTER TYPE NOT FINAL change.

ORA-22343: Compilation error for type invalidated by ALTER TYPE

ORA-22343: Compilation error for type invalidated by ALTER TYPE

Cause: Compilation failed for a type which was invalidated by ALTER TYPE. We throw this error and rollback the compilation effort so that the user may be able to fix whatever is causing the compilation error and try again. It is important that we do not chnage status here and modify the dependency information as this will affect the creation of versions.

Action: Check what is causing teh compilation error and correct it and try again.

ORA-22342: dependent VARRAY column exceeds the maximum inline column size

ORA-22342: dependent VARRAY column exceeds the maximum inline column size

Cause: An attempt was made to alter a type (add or modify attribute) which causes the size of its dependent VARRAY column to exceed the maximum inline column size. However, the VARRAY column was not specified to be stored as LOB at the table level when the table was created.

Action: Specify the VARRAY column to be stored as LOB at the table level when the table is created.

ORA-22341: cannot assign supertype instance to subtype

ORA-22341: cannot assign supertype instance to subtype

Cause: An attempt was made to assign or copy a supertype instance to a container (destination) that can only hold a subtype instance.

Action: Make sure the runtime type of the source of the assignment or copy is the same type as the destination or is a subtype of the destination type

ORA-22340: cannot string type string . string . Dependent tables must be upgraded to latest version

ORA-22340: cannot string type string . string . Dependent tables must be upgraded to latest version

Cause: An attempt was made to reset the version, drop or alter a type when the data in dependent table has not been upgraded to the latest version.

Action: Use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade the data in the dependent tables then resubmit the statement.

ORA-22339: cannot alter to not final since its attribute column is substitutable

ORA-22339: cannot alter to not final since its attribute column is substitutable

Cause: An attempt was made to alter a type to not final when its embedded attribute is defined as substitutable in some tables. Note, this is a restriction in 9.0 version because when a type is altered to not final, column of that type is set to not substitutable at all levels; thus, it is an error if one of its embedded attribute column is already marked substitutable.

Action: Recreate the table and specify NOT SUBSTITUTABLE AT ALL LEVELS for all columns of non final type. Then resubmit the ALTER TYPE statement.

ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property

ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property

Cause: An attempt was made to alter the final property of a type with dependent table(s) without specifying the CASCADE INCLUDING DATA . option.

Action: Resubmit the statement with the CASCADE INCLUDING DATA option.

ORA-22337: the type of accessed object has been evolved

ORA-22337: the type of accessed object has been evolved

Cause: The type of the accessed object has been altered and the client s object is based on an earlier type definition.

Action: The user needs to exit application and modify application to accommodate the type change. From SQL or PLUS, reconnect and resubmit statement.

ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA

ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA

Cause: One of the following: 1) An attempt was made to alter a type with a dependent table in 8.0 image format and the NOT INCLUDING TABLE DATA option was specified. 2) An attempt was made to upgrade a table in 8.0 image format with the NOT INCLUDING DATA option specified.

Action: Resubmit the statement with INCLUDING DATA option.

ORA-22335: The client cannot work with an altered type

ORA-22335: The client cannot work with an altered type

Cause: A pre 8.2 client has requested a type that has been altered on the server.

Action: Only 8.2 or higher clients could access altered types

ORA-22334: cannot reset type string . string . Dependent tables must be upgraded to latest version

ORA-22334: cannot reset type string . string . Dependent tables must be upgraded to latest version

Cause: An attempt was made to reset the type version when the data in the dependent table has not been upgraded to the latest type version.

Action: Use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade the data in the dependent tables then resubmit the statement.

ORA-22333: cannot reset type string . string due to invalid dependent types and tables

ORA-22333: cannot reset type string . string due to invalid dependent types and tables

Cause: An attempt was made to reset the type version with invalid dependent types and tables.

Action: Use the ALTER TYPE COMPILE statement to compile all invalid dependent types and use the ALTER TABLE UPGRADE INCLUDING DATA to upgrade all the dependent tables then resubmit the statement.

ORA-22332: a dependent object in schema string has errors. string

ORA-22332: a dependent object in schema string has errors. string

Cause: Altering the target type causes errors in its dependent object.

Action: Correct the problem in the dependent object and resubmit the statement.

ORA-22331: cannot alter an incomplete type

ORA-22331: cannot alter an incomplete type

Cause: An attempt was made to perform ALTER TYPE on an incomplete type.

Action: Use CREATE TYPE to completely define the original type before executing the ALTER TYPE.

ORA-22330: cannot alter a type that is not valid

ORA-22330: cannot alter a type that is not valid

Cause: An attempt was made to perform ALTER TYPE on an invalid type.

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

ORA-22329: cannot alter a non-object type

ORA-22329: cannot alter a non-object type

Cause: An attempt was made to execute ALTER TYPE on a non-object type.

Action: Drop the non-object type first, then re-create it as an object type.

ORA-22328: object string . string has errors. string

ORA-22328: object string . string has errors. string

Cause: Altering the target type causes errors in its dependent object.

Action: Correct the problem in the dependent object and resubmit the statement.

ORA-22327: cannot change a type to NOT INSTANTIABLE if it has dependent tables

ORA-22327: cannot change a type to NOT INSTANTIABLE if it has dependent tables

Cause: An attempt was made to change a type with dependent tables to NOT INSTANTIABLE.

Action: Drop all dependent tables of the target type and resubmit the statement.

ORA-22326: cannot change a type to FINAL if it has subtypes

ORA-22326: cannot change a type to FINAL if it has subtypes

Cause: An attempt was made to change a type with subtypes to FINAL.

Action: Drop all subtypes of the target type before changing it to FINAL.

ORA-22324: altered type has compilation errors

ORA-22324: altered type has compilation errors

Cause: The use of the ALTER TYPE statement caused a compilation error.

Action: Correct the error reported and resubmit the statement.

ORA-22323: error table string . string does not exist

ORA-22323: error table string . string does not exist

Cause: The error table does not exist.

Action: Resubmit the statement with a correct error table name.

ORA-22322: error table string . string has incorrect structure

ORA-22322: error table string . string has incorrect structure

Cause: The specified error table does not have the expected table structure.

Action: Execute the DBMS_UTILITY.CREATE_ALTER_TYPE_ERROR_TABLE procedure to create an error table, then resubmit the statement using the new error table.

ORA-22321: method does not return any result

ORA-22321: method does not return any result

Cause: OCITypeResult() was called on a method that does not return any results.

Action: Check that you are passing in the correct method descriptor, or that your method creation was done correctly.

ORA-22320: missing user version string

ORA-22320: missing user version string

Cause: The VERSION option is specified without a user version string.

Action: Resubmit the statement with the version string following the VERSION keyword.

ORA-22319: type attribute information altered in ALTER TYPE

ORA-22319: type attribute information altered in ALTER TYPE

Cause: The type attribute information does not match that of the original type declaration when altering type. Attributes cannot be altered during ALTER TYPE. Only new methods can be added.

Action: Check that all type alterations are legal.

ORA-22318: input type is not an array type

ORA-22318: input type is not an array type

Cause: The user is trying to obtain the number of elements for a non-array type.

Action: Pass in only a named collection type which is an array.

ORA-22317: typecode number is not legal as a number type

ORA-22317: typecode number is not legal as a number type

Cause: The user is trying to use a number typecode that is not valid.

Action: Use only OCI_TYPECODE_SMALLINT, OCI_TYPECODE_INTEGER, OCI_TYPECODE_REAL, OCI_TYPECODE_DOUBLE, OCI_TYPECODE_FLOAT, OCI_TYPECODE_NUMBER, or OCI_TYPECODE_DECIMAL.

ORA-22316: input type is not a collection type

ORA-22316: input type is not a collection type

Cause: The user is trying to obtain information for collection types on a non-named collection type.

Action: Use a named collection type for the function.

ORA-22315: type string does not contain a map or order function

ORA-22315: type string does not contain a map or order function

Cause: The input type does not contain a map or order function so one cannot be returned.

Action: Add a map or order function to the type or catch this error.

ORA-22314: method information mismatch in ALTER TYPE

ORA-22314: method information mismatch in ALTER TYPE

Cause: The number of methods or the method signature do not match that of the original type declaration. This is not supported.

Action: Make sure the method signature stay identical for the previously declared method. Do not drop existing methods.

ORA-22313: cannot use two versions of the same type string

ORA-22313: cannot use two versions of the same type string

Cause: The version of this type conflicts with the version of this type used by another library that was linked in with the application. An application may only use one version of a type.

Action: Check that the libraries being linked with this application and use the same versions of the type.

ORA-22312: must specify either CASCADE or INVALIDATE option

ORA-22312: must specify either CASCADE or INVALIDATE option

Cause: An attempt was made to alter a type which has a dependent type or table without specifying the CASCADE or INVALIDATE option.

Action: Resubmit the statement with either the CASCADE or INVALIDATE option. Specify CASCADE if you want to cascade the type change to dependent types and tables; otherwise, specify INVALIDATE to invalidate all dependents.

ORA-22311: type for attribute string does not exist

ORA-22311: type for attribute string does not exist

Cause: The type of the attribute does not exist.

Action: No types were created or modified for this DDL transaction. Redo the DDL transaction and add the creation of the attribute s type in the DDL transaction.

ORA-22310: ALTER TYPE error. Refer to table string . string for errors

ORA-22310: ALTER TYPE error. Refer to table string . string for errors

Cause: An invalid alter type statement was submitted.

Action: Correct the errors listed in specified table and resubmit statement.

ORA-22309: attribute with name string already exists

ORA-22309: attribute with name string already exists

Cause: The user is attempting to create an object type where more than one attributes have the same name.

Action: Check to make sure that all attribute names are unique.

ORA-22308: operation not allowed on evolved type

ORA-22308: operation not allowed on evolved type

Cause: An attempt was made to replace a type whose attribute definition been been altered.

Action: Submit ALTER TYPE ADD or DROP statement instead of ALTER TYPE REPLACE.

ORA-22307: operation must be on a user-defined type

ORA-22307: operation must be on a user-defined type

Cause: attempt to perform an operation that is allowed only on a user-defined type, and the type is not a user-defined type.

Action: Check to make sure that only user-defined types are being operated on.

ORA-22306: type string . string already exists

ORA-22306: type string . string already exists

Cause: The user is trying to create a type that already exists.

Action: Check to make sure that the type has not been created prior to this.

ORA-22305: attribute or method or parameter string not found

ORA-22305: attribute or method or parameter string not found

Cause: Type element with the given name is not found in the type.

Action: Check to make sure that the type element exists.

ORA-22304: input type is not an object type

ORA-22304: input type is not an object type

Cause: The user is trying to obtain the supertype information for a non-object type.

Action: Pass in only an object type.