Oracle Database Errors or Warnings from Error ORA-22344 to ORA-22373


ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
Cause: An attempt was made to specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change.
Action: Specify CONVERT TO SUBSTITUTABLE option only for ALTER TYPE NOT FINAL change.
ORA-22345: recompile type string.string before attempting this operation
Cause: An attempt was made to perform an operation which requires the specified datatype to be valid, but the datatype is invalid
Action: Recompile the specified type and retry the operation
ORA-22346: Type has cyclical dependency. Should use CASCADE option
Cause: An attempt was made to alter a type which has a cyclical dependency, with invalidate option.
Action: Give CASCADE option instead of INVALIDATE

ORA-22347: No changes to type specified for ALTER TYPE
Cause: The ALTER TYPE does not contain any changes to the type.
Action: If any change is required for the type, modify the ALTER TYPE to specify the change. Else no need for the ALTER.
ORA-22369: invalid parameter encountered in method string
Cause: An invalid parameter is being passed to this method of SYS.AnyType ,SYS.AnyData or SYS.AnyDataSet
Action: Check the parameters being passed to this method and make sure that the parameters are allowed.

ORA-22370: incorrect usage of method string
Cause: This method of SYS.AnyType or SYS.AnyData or SYS.AnyDataSet is being used inappropriately.
Action: Check the documentation for correct usage.
ORA-22371: Table contains data of type string.string, version string, which does not exist
Cause: Some of the older versions of the type may have got deleted because one or more of the types it were referencing was dropped.
Action: These data could not be read as the whole ADT. Read the data at individual scalar attribute level.
ORA-22372: Event for type dictionary upgrade
Cause: This is an internally used event for type dictionary upgrades from 8.0 to 8.1.
Action: None
ORA-22373: Older version hashcode encountered
Cause: An older version HC is encountered when creating a new version hahscode. Currently this is handled internally.
Action: None

Above are list of Oracle Database Errors or Warnings from Error ORA-22344 to ORA-22373 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 *