{"id":1994,"date":"2016-05-18T14:58:40","date_gmt":"2016-05-18T11:58:40","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1994"},"modified":"2016-11-02T15:00:06","modified_gmt":"2016-11-02T12:00:06","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-22800-to-ora-23000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-22800-to-ora-23000\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-22800 to ORA-23000"},"content":{"rendered":"

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

\n
ORA-22800: invalid user-defined type<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use an incomplete type as a constructor.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Complete the type definition before using it in a query.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22801: invalid object row variable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified object row variable is not available in the scope of name resolution.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify the specified object row variable is correct, or use an object row variable visible in scope.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22802: remote implementation type not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Remote type reference was not supported<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use local implementation type with user-defined aggregate function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22803: object type contains zero attributes<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify a valid object type<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22804: remote operations not permitted on object tables or user-defined type columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22805: cannot insert NULL object into object tables or nested tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to insert a NULL object into an object table or a Nested Table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that a non-NULL object is inserted into the table or insert an object with attributes whose values are NULL.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22806: not an object or REF<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to extract an attribute from an item that is neither an object nor a REF.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use an object type or REF type item and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22807: cannot resolve to a scalar type or a collection type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Invalid use of a non-scalar (for example, object type) item.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the item’s data type and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22808: REF dereferencing not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to access an object type’s attributes by dereferencing a REF item.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make the item an object type instead of a REF to an object type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22809: nonexistent attribute<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to access a non-existent attribute of an object type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the attribute reference to see if it is valid. Then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22810: cannot modify object attributes with REF dereferencing<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to modify the attributes an object by dereferencing a REF column in an UPDATE statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Update the table containing the object that the REF points to, or change the REF column to an object type column.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22812: cannot reference nested table column’s storage table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to access the nested table column’s storage table is not allowed in the given context.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue the statement against the parent table containing the nested table column.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-22813: operand value exceeds system limits<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Object or Collection value was too large. The size of the value might have exceeded 30k in a SORT context, or the size might be too big for available memory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose another value and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22814: attribute or element value is larger than specified in type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Value provided for the object type attribute or collection element exceeded the size specified in the type declaration.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose another value and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22816: unsupported feature with RETURNING clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0RETURNING clause is currently not supported for object type columns, LONG columns, remote tables, INSERT with subquery, and INSTEAD OF Triggers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use separate select statement to get the values.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22817: subquery not allowed in the default clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use a subquery in the column default clause expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the subquery from the default clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22818: subquery expressions not allowed here<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use a subquery expression where these are not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rewrite the statement without the subquery expression.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22819: scope of input value does not correspond to the scope of the target<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to operate on a REF value scoped to a different table than the expected one<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a ref which is scoped to the expected table and retry the operation<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22826: cannot construct an instance of a non instantiable type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use a non instantiable type as a constructor.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22828: input pattern or replacement parameters exceed 32K size limit<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Value provided for the pattern or replacement string in the form of VARCHAR2 or CLOB for LOB SQL functions exceeded the 32K size limit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a shorter pattern or process a long pattern string in multiple passes.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22833: Must cast a transient type to a persistent type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use the transient type in the query result.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Cast the transient type to a structurally equivalent persistent type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual:\u00a0string<\/i>, maximum:\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to convert CLOB to CHAR or BLOB to RAW, where the LOB size was bigger than the buffer limit for CHAR and RAW types. Note that widths are reported in characters if character length semantics are in effect for the column, otherwise widths are reported in bytes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do one of the following:<\/span><\/span><\/span><\/dd>\n
1. Make the LOB smaller before performing the conversion, for example, by using SUBSTR on CLOB<\/span><\/span><\/span><\/dd>\n
2. Use DBMS_LOB.SUBSTR to convert CLOB to CHAR or BLOB to RAW.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22837: Relational hint or keyword is disallowed for user-level DML<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use relational hint or keyword in user- level DML.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Avoid using DML with relational hint or keyword.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22839: Direct updates on SYS_NC columns are disallowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to update SYS_NC columns directly.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Avoid direct updates on SYS_NC columns.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22850: duplicate LOB storage option specificed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A LOB storage option (CHUNK, PCTVERSION, CACHE, NOCACHE, TABLESPACE, STORAGE, INDEX, SECUREFULE\/BASICFILE, [A]SYNC) was specified more than once.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify all LOB storage options only once.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22851: invalid CHUNK LOB storage option value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified CHUNK LOB storage option value must be an integer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose an appropriate integer value and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22852: invalid PCTVERSION LOB storage option value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified PCTVERSION LOB storage option value must be an integer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose an appropriate integer value and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22853: invalid LOB storage option specification<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A LOB storage option was not specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify one of CHUNK, PCTVERSION, CACHE, NOCACHE, TABLESPACE, STORAGE, INDEX, [A]SYNC or DATA SYNC as part of the LOB storage clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22854: invalid option for LOB storage index<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A valid LOB store index option was not specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify one of (INITRANS, MAXTRANS, TABLESPACE, STORAGE) as part of the LOB storage index.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22855: optional name for LOB storage segment incorrectly specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The optional name for LOB storage segment was specified with multiple columns in the column list.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify each column LOB storage only with optional name(s).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22856: cannot add columns to object tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to add columns to an object table. Object tables cannot be altered to add columns since its definition is based on an object type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a new type with additional attributes, and use the new type to create an object table. The new object table will have the desired columns.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22857: cannot modify columns of object tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to alter the object table by modifing existing columns. An object table cannot be altered to modify existing columns since it is based on an object type. The table definition must be in sync with the corresponding type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a new type with the desired attribute types and use it to create an object table. The new object table will have the desired columns.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22858: invalid alteration of datatype<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to modify the column type to object, REF, nested table, VARRAY or LOB type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a new column of the desired type and copy the current column data to the new type using the appropriate type constructor.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22859: invalid modification of columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to modify an object, REF, VARRAY, nested table, or LOB column type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a new column of the desired type and copy the current column data to the new type using the appropriate type constructor.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22860: object type expected<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create an object table using a non- object type, or to create a column that is a REF to a non-object type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a valid object type in the table or column definition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22861: invalid user-defined type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a column or object table of a non- existent type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid type in the table or column definition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22862: specified object identifier doesn’t match existing object identifier<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify an object identifier for the type that does not match the existing identifier of the incomplete type of the same name.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the correct object identifier or leave it out of the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22863: synonym for datatype\u00a0string<\/i>.string<\/i>\u00a0not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A synonym specification for a datatype is not supported<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0do not use the synonym for the datatype<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22864: cannot ALTER or DROP LOB indexes<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to ALTER or DROP a LOB index.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not operate directly on the system-defined LOB index. Perform operations on the corresponding LOB column.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22865: more than one column specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify multiple columns where only one is allowed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a single column and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22866: cannot replace a type with table dependents<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to replace a type that has table dependents.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all table(s) depending on the type, then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22868: table with LOBs contains segments in different tablespaces<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a tablespace which contains the segment(s) for the LOB columns of a table but does not contain the table segment.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Find table(s) with LOB columns which have non-table segments in this tablespace. Drop these tables and reissue drop tablespace.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22869: depth of type dependency hierarchy exceeds maximum limit<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The type dependency hierarchy was structured to have depth greater than 1024.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-structure the type dependency hierarchy to a shorter depth.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22870: ALTER TYPE with REPLACE option a non-object type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempt to perform ALTER TYPE with REPLACE option 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-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to perform ALTER TYPE with REPLACE option for a pure incomplete type<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Completely define the original type, before using the ALTER TYPE with REPLACE option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to create an OID INDEX on a table with primary key based object identifiers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the OID INDEX clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22873: primary key not specified for primary key based object table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to create a primary key based object table without specifying a primary key<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a primary key and retry the operation<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22874: attribute “string<\/i>” is not part of the type “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attribute specified in the user_defined clause is not an attribute of the REF type<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the name specified in the user_defined clause is the name of a valid attribute of the REF type<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to drop the primary key of an object table which has a primary key based object identifier<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the drop primary key clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22876: this user-defined type is not allowed or it cannot be used in this context<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to create a kind of user-defined type which is not allowed, or an attempt to create table columns or use default constructor with a type on which these are not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the type is permitted in this context.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22877: invalid option specified for a HASH partition or subpartition of a LOB column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One or more invalid options were encountered while parsing the physical attributes of a LOB partition or subpartition. Either the LOB partition is in a table partitioned using the HASH method, or the LOB subpartition is in a table subpartitioned using the HASH method. TABLESPACE is the only valid option for a HASH partition or subpartition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the invalid option(s).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22878: duplicate LOB partition or subpartition specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify a partition or subpartition that has already been specified for the LOB column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the duplicate specification.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22879: cannot use the LOB INDEX clause for partitioned tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify a LOB INDEX clause in a CREATE TABLE or ALTER TABLE statement for a partitioned table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the LOB INDEX clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22880: invalid REF<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid REF was accessed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Modify the REF and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22881: dangling REF<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object corresponding to the REF that was accessed does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the REF value is pointing to an existing object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22882: object creation failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object cannot be created in the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to see if the object table exists and the object size is not too big. Then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22883: object deletion failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object could not be deleted from the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to see if the object table exists.Then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22884: object modification failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object could not be modified in the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to see if the object table exists and the object size is not too big. Then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22885: cannot get REF to a non-persistent object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rewrite the query to obtain REF values from object tables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22886: scoped table “string<\/i>” in schema “string<\/i>” is not an object table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The scoped table specified for a REF column is not an object table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the scoped table is an object table.Then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22887: type of REF column is not the same as that of its scoped table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The type specified for the REF column and the type specified for the scope table are different.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the types of a REF column and its scoped table are the same.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22888: duplicate SCOPE clauses for a REF column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Multiple SCOPE clauses were specified for a single REF column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the duplicate SCOPE clauses and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22889: REF value does not point to scoped table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to insert a REF value that does not point to the scoped table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the REF values point to the scoped table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22890: cannot specify name for REF column constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify a constraint name for a constraint on a REF column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the constraint name and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22891: cannot have multiple columns in REF constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify multiple columns in a single REF constraint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify separate constraints for each column and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22892: scoped table “string<\/i>” does not exist in schema “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The scoped table specified for a REF column does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the scoped table exists and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22893: constraint can be specified only for REF columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The constraint specified does not apply to non-REF columns.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the constraint and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to add a constraint to existing unscoped REF columns of a table which contains one or more rows.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the constraint specification or add the constraint after emptying the table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22895: referenced table “string<\/i>” in schema “string<\/i>” is not an object table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The referenced table specified for a REF column is not an object table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the referenced table is an object table.Then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22896: cannot have both scope and referential constraint on REF column “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0REF column has both a referential and a scope constraint. A referential constraint implies a scope constraint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove either the referential or scope constraint and then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22897: no scope clause specified for user-defined REF column “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User-defined REF column does not have a scope constraint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a scope constraint for the user-defined REF column and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22898: existing scope clause on “string<\/i>” points to a table other than the one mentioned in the referential constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Table mentioned in the referential integrity constraint is different from the scope table of the REF column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the scope table of the REF column in the referential integrity constraint and then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22899: cannot specify both scope and rowid constraint on ref column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify both a scope and a rowid constraint on a REF column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove either the rowid or scope constraint and then retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22900: the SELECT list item of THE subquery is not a collection type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The THE subquery must SELECT a nested table or VARRAY item.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0change the subquery to SELECT a nested table or VARRAY item.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22901: cannot compare VARRAY or LOB attributes of an object type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Comparison of VARRAY or LOB attributes of an object type was attempted in the absence of a MAP or ORDER method.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Define a MAP or ORDER method for the object type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22902: CURSOR expression not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0CURSOR on a subquery is allowed only in the top-level SELECT list of a query.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22903: MULTISET expression not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0MULTISET expressions are allowed only inside a CAST to a nested table or VARRAY type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0put the MULTISET(subquery) expression inside a CAST to a nested table or VARRAY type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22904: invalid reference to a nested table column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0invalid use of a nested table column<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0remove invalid reference to the nested table column<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22905: cannot access rows from a non-nested table item<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempt to access rows of an item whose type is not known at parse time or that is not of a nested table type<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0use CAST to cast the item to a nested table type<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22906: cannot perform DML on expression or on nested table view column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to perform a DML on an expression or on a nested table view column where a nested table column of a base table is expected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only nested table column of a base table is allowed in the DML.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22907: invalid CAST to a type that is not a nested table or VARRAY<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to CAST to a type that is not a nested table or VARRAY<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-specify CAST to a nested table or VARRAY type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22908: reference to NULL table value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The evaluation of the THE subquery or nested table column resulted in a NULL value implying a NULL table instance. The THE subquery or nested table column must identify a single non-NULL table instance.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the evaluation of the THE subquery or nested table column results in a single non-null table instance. If happening in the context of an insert statement where the THE subquery is the target of an insert, then ensure that an empty nested table instance is created by updating the nested table column of the parent table’s row specifying an empty nested table constructor.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22909: exceeded maximum VARRAY limit<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The total number of elements used in VARRAY construction exceeds the specified VARRAY limit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Don’t use the more than the specified limit of elements for VARRAY construction.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22910: cannot specify schema name for nested tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Table name was qualified with schema name in the nested table column’s (or attribute’s) storage clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-specify the nested table item’s storage clause without the schema name qualification. By default, the storage table for the nested table item is created in the same schema as the containing table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22911: duplicate storage specification for the nested table item<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The storage clause is specified more than once for the NESTED TABLE column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the duplicate storage specification.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22912: specified column or attribute is not a nested table type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The storage clause is specified for a column or attribute that is not a nested table column or attribute.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid nested table column or attribute.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22913: must specify table name for nested table column or attribute<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The storage clause is not specified for a nested table column or attribute.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the nested table storage clause for the nested table column or attribute.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22914: DROP of nested tables not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to DROP a nested table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0nested tables cannot be explicitly dropped. nested tables can only be dropped by dropping their containing parent table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22915: cannot ALTER a nested table’s storage table to ADD\/MODIFY columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0any such change.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Columns cannot be added or modified for a nested table’s storage table. You must alter the parent table’s nested table column to<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22916: cannot do an exact FETCH on a query with Nested cursors<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Exact FETCH on a query was specified which is not allowed if the query returns any cursors.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use an exact FETCH.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22917: use VARRAY to define the storage clause for this column or attribute<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Not using VARRAY to define storage clause for VARRAY column or attribute.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify VARRAY before the column storage clause and resubmit statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22918: specified column or attribute is not a VARRAY type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attemp to define a VARRAY storage clause for a column or attribute which is not VARRAY type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify VARRAY storage clause for a VARRAY column or attribute.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22919: dangling REF error or lock object failed for no wait request<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The error could be one of the following. The object corresponding to the REF does not exist or the object was locked by another user and the lock with nowait request failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the REF value is pointing to an existing object or issue a lock request without the nowait option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22920: row containing the LOB value is not locked<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The row containing the LOB value must be locked before updating the LOB value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Lock the row containing the LOB value before updating the LOB value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22921: length of input buffer is smaller than amount requested<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The buffer length is not big enough to hold the amount of data requested.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the number of bytes\/characters specified in the input amount parameter is not bigger than the number of bytes specified in the input buffer length parameter. Allocate more space for the input buffer if necessary.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22922: nonexistent LOB value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The LOB value associated with the input locator does not exist. The information in the locator does not refer to an existing LOB.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Repopulate the locator by issuing a select statement and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22923: amount of data specified in streaming LOB write is 0<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to write LOB value via the streaming mechanism (i.e. unlimited write) but the input amount of data to stream was specified as 0. Thus, the user is trying to write 0 bytes to the LOB value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Write more than 0 bytes to the LOB value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22924: snapshot too old<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The version of the LOB value needed for the consistent read was already overwritten by another writer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a larger version pool.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22925: operation would exceed maximum size allowed for a LOB value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to write too much data to the LOB value. LOB size is limited to 4 gigabytes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either start writing at a smaller LOB offset or write less data to the LOB value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22926: specified trim length is greater than current LOB value’s length<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The input length for which to trim the LOB value to is greater than the current length of the LOB value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0May not need to trim the LOB value because it’s already smaller than the trim length specified. Or, if trimming the LOB value really is required, use a smaller trim length.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22927: invalid LOB locator specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There are several causes: (1) the LOB locator was never initialized; (2) the locator is for a BFILE and the routine expects a BLOB\/CLOB\/NCLOB locator; (3) the locator is for a BLOB\/CLOB\/NCLOB and the routine expects a BFILE locator; (4) trying to update the LOB in a trigger body — LOBs in trigger bodies are read only.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0For (1), initialize the LOB locator by selecting into the locator variable or by setting the LOB locator to empty. For (2) and (3), pass the correct type of locator into the routine. For (4), remove the trigger body code that updates the LOB value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22928: invalid privilege on directories<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to grant or revoke an invalid privilege on a directory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only CREATE, DELETE, READ, WRITE and EXECUTE privileges can be granted or revoked on directories. Do not grant or revoke other privileges.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22929: invalid or missing directory name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The required directory name is invalid or missing.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22930: directory does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to access a directory that does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the name is correct.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22933: cannot change object with type or table dependents<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to replace, drop or rename an object with type or table dependents.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop depending objects or use FORCE option if available.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22936: cannot replace a system predefined type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to replace a system predefined type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use other names for newly created system types.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22950: cannot ORDER objects without MAP or ORDER method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0an object type must have a MAP or ORDER method defined for all comparisons other than equality and inequality comparisons.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Define a MAP or ORDER method for the object type<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22951: NULL returned by ORDER method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORDER method used to compare two object values returned NULL which is not allowed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Redefine the ORDER method to not return a NULL.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22952: Nested Table equality requires a map method on the element ADT<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Nested Table equality was tried where the element ADT did not have a map method defined on it.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Define a map method on the element ADT..<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22953: Cardinality of the input to powermultiset exceeds maximum allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The cardinality of the input nested table to the powermultiset should not exceed 32 elements<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reduce the number of elements to the input.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22954: This multiset operation is not supported for this element type.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The multiset operation attempted was not supported for the nested table element type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a supported element type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22955: The cardinality parameter is not within the allowed limits<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The cardinality parameter has to be greater than 1 and less than or equal to the cardinality of the input.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Give a valid cardinality value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22956: The set contains no elements<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An empty set was given as input to the powermultiset function.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Give a non-empty set as input<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0NULL was given as input to the powermultiset or COLLECT function.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Give a non-null value as input<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22958: This operation is not allowed in check constraints or triggers<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid operation is used in a check constraint or trigger<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the operation<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22970: name does not correspond to an object view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either the expression is not a view name or the name specified does not correspond to an object view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Replace the expression with the name of an object view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22971: invalid datatype for PRIMARY KEY-based object identifier<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When creating an object view, the datatype of an expression in the WITH OBJECT OID clause is not allowed for PRIMARY KEY-based OID.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Replace the expression with one of appropriate scalar datatype.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22972: NULL value not allowed in PRIMARY KEY-based object identifier<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A value constituting the PRIMARY KEY-based object identifier is NULL.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure the expressions in MAKE_REF system function or attributes in the WITH OBJECT OID clause of an object view do not evaluate to NULL.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22973: size of object identifier exceeds maximum size allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Size of the PRIMARY KEY-based object identifier of an object view exceeds the maximum size of 4000 bytes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify fewer or smaller PRIMARY KEY attributes in the WITH object OID clause when creating the object view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22974: missing WITH OBJECT OID clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0WITH OBJECT OID clause is not specified when creating an object view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the WITH OBJECT OID clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22975: cannot create a PRIMARY KEY-based REF to this object view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object view specified in the MAKE_REF function does not have a PRIMARY KEY-based object identifier. A PRIMARY KEY-based REF cannot be created for such a view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify an object view that has a PRIMARY KEY-based object identifier in the MAKE_REF function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22976: incorrect number of arguments to MAKE_REF<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Number of arguments for MAKE_REF is different from the number of PRIMARY KEY attributes of the object view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify all the necessary arguments for MAKE_REF.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22977: missing or invalid attribute<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either the attribute name is missing in the WITH OBJECT OID clause or it is invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid attribute of the object type of the object view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to specify a Nested attribute in the WITH OBJECT OID clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a top-level attribute of the object type of the object view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22979: cannot INSERT object view REF or user-defined REF<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to insert an object view REF or user-defined REF in a REF column created to store system generated REF values”<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the REF to be inserted is not from an object view or from a user-defined REF column<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The WITH OBJECT OID DEFAULT clause was used, but the underlying view or table does not have a OID.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify attributes for the WITH OBJECT OID clause to create a primary key based object identifier for the object view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22981: must specify a table\/view having system generated OID<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The super-view is based on a table\/view having the system generated OID and the sub-view must also be based on a similar table\/view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify table\/view having system generated OID and retry the the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22982: cannot create sub-view under this view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The view derives its OID from a table\/view having primary key based OID and sub-views cannot be created under such views.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify view having system generated OID or a view created with the specification of attributes in the WITH OBJECT ID clause and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22983: not a user-defined REF<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use a system generated REF value where a user-defined REF value should be used.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the REF value is user-defined.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22984: view query cannot contain references to a super view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The query defining the view contains references to a super-view of the view being created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the view query does not reference a super-view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22990: LOB locators cannot span transactions<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A LOB locator selected in one transaction cannot be used in a different transaction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-select the LOB locator and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22991: insufficient space allocated for argument\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The data to be returned in the argument is greater than the amount of space allocated for the argument.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Allocate more space for the argument.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22992: cannot use LOB locators selected from remote tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A remote LOB column cannot be referenced.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove references to LOBs in remote tables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22993: specified input amount is greater than actual source amount<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0(1) For LOB write, the amount of data received is different from the amount that was indicated would be sent. (2) For LOB copy and loadfromfile, the end of the source LOB\/FILE value was reached before the specified input amount was copied\/loaded.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0(1) will happen when using OCI’s piecewise mechanism with polling or with a callback function. Modify the code either to send the amount specified or to pass 0 as the input amount so that any amount of data can be sent. (2) will happen if the specified input amount is too large for the source LOB\/FILE given the starting source offset. Either decrease the starting source offset, or decrease the amount to copy\/load.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22994: source offset is beyond the end of the source LOB<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The source offset for a LOB COPY or LOB LOADFROMFILE is beyond the end of the source LOB.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the length of the LOB and then adjust the source offset.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22995: TABLESPACE DEFAULT option is invalid in this context<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0TABLESPACE DEFAULT option can be specified for LOB columns only in the following contexts:<\/span><\/span><\/span><\/dd>\n
– at the table level for a partitioned table<\/span><\/span><\/span><\/dd>\n
– at the partition level for a composite partition. An attempt was made to use the TABLESPACE DEFAULT option in a different context.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the TABLESPACE DEFAULT option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22996: NEXT extent size is smaller than LOB chunksize<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create or alter a LOB segment so that its NEXT extent size was less than the LOB chunksize<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a NEXT extent size that is greater than or equal to the LOB chunksize<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at the table level<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify a VARRAY|OPAQUE column to be stored as LOB at the partition\/subpartition\/template level. However the VARRAY|OPAQUE 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 | OPAQUE column to be stored as LOB at the table level when the table is created. Alternatively, do not specify the VARRAY | OPAQUE column to be stored as LOB at the partition\/subpartition\/template level if it is not specified at the table level when the table is created.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22998: CLOB or NCLOB in multibyte character set not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A CLOB or NCLOB in a fixed-width or varying-width multibyte character set was passed to a SQL character function which does not support multibyte LOB data.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use DBMS_LOB functions such as DBMS_LOB.INSTR() and DBMS_LOB.SUBSTR()<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-22999: CLOB or NCLOB data may have been corrupted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0CLOB or NCLOB contains invalid character data. One possible cause is that the wrong csid was specified for the external file when calling DBMS_LOB.LOADCLOBFROMFILE or DBMS_XSLPROCESSOR.READ2CLOB to load CLOB or NCLOB data from external files.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reload the CLOB\/NCLOB data with the correct csid specified for the external file.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-22800 to ORA-23000 ORA-22800: invalid user-defined type Cause:\u00a0An attempt was made to use an incomplete type as a constructor. Action:\u00a0Complete the type definition before using it in a query. ORA-22801: invalid object row variable Cause:\u00a0The specified object row variable is not available in the scope of name…<\/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-1994","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-wa","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1994","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=1994"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1994\/revisions"}],"predecessor-version":[{"id":1995,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1994\/revisions\/1995"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1994"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}