Oracle Database Errors or Warnings from Error ORA-22313 to ORA-22322


ORA-22313: cannot use two versions of the same type “string”
Cause: The version of this type conflicts with the version of this type used by another library that was linked in with the application. An application may only use one version of a type.
Action: Check that the libraries being linked with this application and use the same versions of the type.
ORA-22314: method information mismatch in ALTER TYPE
Cause: The number of methods or the method signature do not match that of the original type declaration. This is not supported.
Action: Make sure the method signature stay identical for the previously declared method. Do not drop existing methods.
ORA-22315: type “string” does not contain a map or order function
Cause: The input type does not contain a map or order function so one cannot be returned.
Action: Add a map or order function to the type or catch this error.

ORA-22316: input type is not a collection type
Cause: The user is trying to obtain information for collection types on a non-named collection type.
Action: Use a named collection type for the function.
ORA-22317: typecode number is not legal as a number type
Cause: The user is trying to use a number typecode that is not valid.
ORA-22318: input type is not an array type
Cause: The user is trying to obtain the number of elements for a non-array type.
Action: Pass in only a named collection type which is an array.

ORA-22319: type attribute information altered in ALTER TYPE
Cause: The type attribute information does not match that of the original type declaration when altering type. Attributes cannot be altered during ALTER TYPE. Only new methods can be added.
Action: Check that all type alterations are legal.
ORA-22320: missing user version string
Cause: The VERSION option is specified without a user version string.
Action: Resubmit the statement with the version string following the VERSION keyword.
ORA-22321: method does not return any result
Cause: OCITypeResult() was called on a method that does not return any results.
Action: Check that you are passing in the correct method descriptor, or that your method creation was done correctly.
ORA-22322: error table “string”.”string” has incorrect structure
Cause: The specified error table does not have the expected table structure.
Action: Execute the DBMS_UTILITY.CREATE_ALTER_TYPE_ERROR_TABLE procedure to create an error table, then resubmit the statement using the new error table.

Above are list of Oracle Database Errors or Warnings from Error ORA-22313 to ORA-22322 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *