{"id":1992,"date":"2016-05-17T14:55:52","date_gmt":"2016-05-17T11:55:52","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1992"},"modified":"2016-11-02T14:57:48","modified_gmt":"2016-11-02T11:57:48","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-22300-to-ora-22700","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-22300-to-ora-22700\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-22300 to ORA-22700"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-22300 to ORA-22700<\/strong><\/p>\n

\n
ORA-22303: type “string”.”string” not found<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user is trying to obtain information for a type that cannot be found.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the schema is correct and that the type has been created correctly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22304: input type is not an object type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user is trying to obtain the supertype information for a non-object type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Pass in only an object type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22305: attribute\/method\/parameter “string<\/i>” not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Type element with the given name is not found in the type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to make sure that the type element exists.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22306: type “string<\/i>“.”string<\/i>” already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user is trying to create a type that already exists.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to make sure that the type has not been created prior to this.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22307: operation must be on a user-defined type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempt to perform an operation that is allowed only on a user-defined type, and the type is not a user-defined type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to make sure that only user-defined types are being operated on.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22308: operation not allowed on evolved type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to replace a type whose attribute definition been been altered.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Submit ALTER TYPE ADD\/DROP statement instead of ALTER TYPE REPLACE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22309: attribute with name “string<\/i>” already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user is attempting to create an object type where more than one attributes have the same name.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to make sure that all attribute names are unique.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22310: ALTER TYPE error. Refer to table “string<\/i>“.”string<\/i>” for errors<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid alter type statement was submitted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the errors listed in specified table and resubmit statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22311: type for attribute “string<\/i>” does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The type of the attribute does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No types were created\/modified for this DDL transaction. Redo the DDL transaction and add the creation of the attribute’s type in the DDL transaction.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22312: must specify either CASCADE or INVALIDATE option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to alter a type which has a dependent type or table without specifying the CASCADE or INVALIDATE option.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Resubmit 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22313: cannot use two versions of the same type “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the libraries being linked with this application and use the same versions of the type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22314: method information mismatch in ALTER TYPE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number of methods or the method signature do not match that of the original type declaration. This is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the method signature stay identical for the previously declared method. Do not drop existing methods.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-22315: type “string<\/i>” does not contain a map or order function<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The input type does not contain a map or order function so one cannot be returned.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Add a map or order function to the type or catch this error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22316: input type is not a collection type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user is trying to obtain information for collection types on a non-named collection type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a named collection type for the function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22317: typecode\u00a0string<\/i>\u00a0is not legal as a number type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user is trying to use a number typecode that is not valid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use only OCI_TYPECODE_SMALLINT, OCI_TYPECODE_INTEGER, OCI_TYPECODE_REAL, OCI_TYPECODE_DOUBLE, OCI_TYPECODE_FLOAT, OCI_TYPECODE_NUMBER, or OCI_TYPECODE_DECIMAL.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22318: input type is not an array type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user is trying to obtain the number of elements for a non-array type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Pass in only a named collection type which is an array.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22319: type attribute information altered in ALTER TYPE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that all type alterations are legal.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22320: missing user version string<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The VERSION option is specified without a user version string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Resubmit the statement with the version string following the VERSION keyword.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22321: method does not return any result<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0OCITypeResult() was called on a method that does not return any results.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that you are passing in the correct method descriptor, or that your method creation was done correctly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22322: error table “string<\/i>“.”string<\/i>” has incorrect structure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified error table does not have the expected table structure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Execute the DBMS_UTILITY.CREATE_ALTER_TYPE_ERROR_TABLE procedure to create an error table, then resubmit the statement using the new error table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22323: error table “string<\/i>“.”string<\/i>” does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The error table does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Resubmit the statement with a correct error table name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22324: altered type has compilation errors<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The use of the ALTER TYPE statement caused a compilation error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the error reported and resubmit the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22326: cannot change a type to FINAL if it has subtypes<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to change a type with subtypes to FINAL.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all subtypes of the target type before changing it to FINAL.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22327: cannot change a type to NOT INSTANTIABLE if it has dependent tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to change a type with dependent tables to NOT INSTANTIABLE.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all dependent tables of the target type and resubmit the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22328: object “string<\/i>“.”string<\/i>” has errors.\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Altering the target type causes errors in its dependent object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the problem in the dependent object and resubmit the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22329: cannot alter a non-object type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to execute ALTER TYPE on a non-object type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the non-object type first, then re-create it as an object type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22330: cannot alter a type that is not valid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform ALTER TYPE on an invalid type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the CREATE OR REPLACE TYPE command to modify the type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22331: cannot alter an incomplete type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform ALTER TYPE on an incomplete type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use CREATE TYPE to completely define the original type before executing the ALTER TYPE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22332: a dependent object in schema “string<\/i>” has errors.\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Altering the target type causes errors in its dependent object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the problem in the dependent object and resubmit the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22333: cannot reset type “string<\/i>“.”string<\/i>” due to invalid dependent types and tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to reset the type version with invalid dependent types and tables.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22334: cannot reset type “string<\/i>“.”string<\/i>“. Dependent tables must be upgraded to latest version<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to reset the type version when the data in the dependent table has not been upgraded to the latest type version.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade the data in the dependent tables then resubmit the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22335: The client cannot work with an altered type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A pre 8.2 client has requested a type that has been altered on the server.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only 8.2 or higher clients could access altered types<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Resubmit the statement with INCLUDING DATA option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22337: the type of accessed object has been evolved<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The type of the accessed object has been altered and the client’s object is based on an earlier type definition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The user needs to exit application and modify application to accommodate the type change. From SQL\/PLUS, reconnect and resubmit statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to alter the final property of a type with dependent table(s) without specifying the CASCADE INCLUDING DATA . option.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Resubmit the statement with the CASCADE INCLUDING DATA option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22339: cannot alter to not final since its attribute column is substitutable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recreate the table and specify NOT SUBSTITUTABLE AT ALL LEVELS for all columns of non final type. Then resubmit the ALTER TYPE statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22340: cannot\u00a0string<\/i>\u00a0type “string<\/i>“.”string<\/i>“. Dependent tables must be upgraded to latest version<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade the data in the dependent tables then resubmit the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22341: cannot assign supertype instance to subtype<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to assign or copy a supertype instance to a container (destination) that can only hold a subtype instance.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make 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<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22342: dependent VARRAY column exceeds the maximum inline column size<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the VARRAY column to be stored as LOB at the table level when the table is created.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22343: Compilation error for type invalidated by ALTER TYPE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Compilation 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check what is causing teh compilation error and correct it and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify CONVERT TO SUBSTITUTABLE option only for ALTER TYPE NOT FINAL change.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22345: recompile type\u00a0string<\/i>.string<\/i>\u00a0before attempting this operation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform an operation which requires the specified datatype to be valid, but the datatype is invalid<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recompile the specified type and retry the operation<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22346: Type has cyclical dependency. Should use CASCADE option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to alter a type which has a cyclical dependency, with invalidate option.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Give CASCADE option instead of INVALIDATE<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22347: No changes to type specified for ALTER TYPE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ALTER TYPE does not contain any changes to the type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If any change is required for the type, modify the ALTER TYPE to specify the change. Else no need for the ALTER.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22348: The object type DDL is not supported in Editioned schema<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object type DDL was not supported in an Editioned schema.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not perform this DDL on an Editioned schema object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22350: Incomplete opaque type cannot be used here<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An incomplete SYS.AnyType or SYS.AnyData or SYS.AnyDataSet is being used inappropriately.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the documentation for correct usage.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22369: invalid parameter encountered in method\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid parameter is being passed to this method of SYS.AnyType ,SYS.AnyData or SYS.AnyDataSet<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the parameters being passed to this method and make sure that the parameters are allowed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22370: incorrect usage of method\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This method of SYS.AnyType or SYS.AnyData or SYS.AnyDataSet is being used inappropriately.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the documentation for correct usage.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22371: Table contains data of type\u00a0string<\/i>.string<\/i>, version\u00a0string<\/i>, which does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Some of the older versions of the type may have got deleted because one or more of the types it were referencing was dropped.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0These data could not be read as the whole ADT. Read the data at individual scalar attribute level.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22372: Event for type dictionary upgrade<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This is an internally used event for type dictionary upgrades from 8.0 to 8.1.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22373: Older version hashcode encountered<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An older version HC is encountered when creating a new version hahscode. Currently this is handled internally.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22374: cannot reset the version of a type with table dependents<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The type for which reset version was requested has table dependents.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22375: Event to check for subtypes in complete type tree<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This event is used to check for subtypes in complete type tree without any restriction on depth in the fix for bug# 12430142.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Production 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Delete 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22601: pickler TDS context [string<\/i>] is not initialized<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use the pickler TDS context without initializing it.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use OCIPicklerTdsCtxInit to initialize the context.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22602: pickler TDS handle [string<\/i>] is not well-formed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use the pickler TDS handle without initializing\/ constructing it.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use OCIPicklerTdsInit to initialize the handle before it is constructed. Use OCIPicklerTdsGenerate to generate the TDS before its attributes can be accessed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22603: cannot add an attribute to the already generated TDS handle<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to add an attribute to the already constructed TDS.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a TDS handle that is initialized but not yet constructed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22604: TDS handle already generated<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to geneate TDS that is already genearated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a TDS handle that is initialized but not yet generated.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22605: FDO handle [string<\/i>] is not initialized<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use an uninitialized FDO handle.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use OCIPicklerFdoInit to initialize FDO handle”.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22606: pickler image handle [string<\/i>] is not well-formed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use the image handle without initializing\/ constructing it.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use OCIPicklerImageInit to initialize the handle before it is constructed. Use OCIPicklerImageGenerate to generate the image before its attributes can be accessed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22607: image handle already generated<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to geneate image that is already genearated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a image handle that is initialized but not yet generated.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22608: cannot add an attribute to the already generated image handle<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to add an attribute to the already constructed image.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a image handle that is initialized but not yet constructed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22609: error\u00a0string<\/i>\u00a0during initialization of FDO<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error during FDO initialization.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Take an action based on the specified error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22610: error while adding a scalar to the image handle<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error while adding a scalar attribute to the image handle<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure image handle is initialized before adding scalar<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22611: TDS version is not recognized<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Incorrect TDS handle is passed<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure image handle is initialized with the correct TDS<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22612: TDS does not describe a collection TDS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0collection construct\/access routines are being on an image but the TDS does not describe that a collection TDS<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure a collection TDS is used before invoking collection routines on the image handle<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22613: buflen does not match the size of the scalar<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0buflen is incorrect<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure buflen is correct and matches the size of the scalar<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22614: error while construction the collection in the image<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error during the construction of collection<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure image handle is initialized and OCIPicklerImageCollBegin is called to begin collection<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22615: attribute is not a collection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0collection routine is invoked upon a non-collection attribute<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure attribute is a collection<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22616: image is not of Oracle 8.1 format<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The function being invoked is applicable only for 8.1 images<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure image is of 8.1 format<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22617: error while accessing the image handle collection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error while accessing collection in the image handle<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure image is initialized correctly and the collection is constructed properly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22618: attribute is a BAD NULL in the image handle<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attribute in question is probably the attribute of a null embedded image<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure attribute number is valid or it is NULL or NOT NULL.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22619: all collection elements have already been accessed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Accessing a collection element after all the collection elements are already accessed<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This function should not be invoked any more.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22620: buffer size too small to hold the value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Buffer size is not enough to hold the value. Most likely while doing the character set conversion, a bigger buffer is needed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Pass in a bigger buffer. If the client character set format differs from that of server, doing the conversion may result in 4X expansion.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22621: error transfering an object from the agent<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Any error returned from pickler routines on the agent side.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22625: OCIAnyData is not well-formed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use the OCIAnyData without initializing constructing it.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use OCIAnyDataBeginConstruct to initialize the handle before it is adding attributes. Use OCIAnyDataEndConstruct to complete the construction. Or use OCIAnyDataConvert to do the construction. MAke sure it is properly constructed before accessing attributes.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22626: Type Mismatch while constructing or accessing OCIAnyData<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Type supplied is not matching the type of the AnyData. If piece wise construction or access is being attempted, the type supplied is not matching the type of the current attribute.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the type supplied matches the type of object to to be constucted or accessed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22627: tc [string<\/i>] must be that of object\/varray\/nested table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Type code is not that of object\/varray\/nested table<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the type code is OCI_TYPECODE_OBJECT or OCI_TYPECODE_VARRAY or OCI_TYPECODE_TABLE<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22628: OCIAnyData already constructed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to add attributes to OCIAnyData that is already constructed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the OCIAnyData that is initialized but not yet constructed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22629: OCIAnyData is null<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempting an operation that is not valid on null OCIAnyData<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure OCIAnyData is not null.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22630: attribute [string<\/i>] is null or it is not well-formed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Passing an attribute that is null or not well-formed<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the attribute is not null or is well-formed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22631: attribute [string<\/i>] is is not well-formed or does not match the type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Passing an attribute that is not well-formed or does not match the input type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the attribute is well-formed and matches the type specified.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22632: AnyDataSet parameter is not valid for the current operation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The AnyDataSet parameter is null or it is somehow invalid for the current operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the documentation for the current operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22633: Error freeing AnyDataSet<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0AnyDataSet that is passed in may not be valid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check all the AnyDataSet parameters.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22634: Error adding new instance to AnyDataSet<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Current instance in the AnyDataSet has not been fully constructed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the current instance is fully constructed before adding new instance.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22635: time stamp with time zone type not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0OCIAnyData did not support conversion of time stamp with time zone when the version of time zone files differ.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use same version of time zone files.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-22300 to ORA-22700 ORA-22303: type “string”.”string” not found Cause:\u00a0The user is trying to obtain information for a type that cannot be found. Action:\u00a0Check that the schema is correct and that the type has been created correctly. ORA-22304: input type is not an object type Cause:\u00a0The user is…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1992","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-w8","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1992"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1992\/revisions"}],"predecessor-version":[{"id":1993,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1992\/revisions\/1993"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1992"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}