Oracle Database Errors or Warnings from Error ORA-22303 to ORA-22312

SQLServerF1

ORA-22303: type “string”.”string” not found
Cause: The user is trying to obtain information for a type that cannot be found.
Action: Check that the schema is correct and that the type has been created correctly.
ORA-22304: input type is not an object type
Cause: The user is trying to obtain the supertype information for a non-object type.
Action: Pass in only an object type.
ORA-22305: attribute/method/parameter “string” not found
Cause: Type element with the given name is not found in the type.
Action: Check to make sure that the type element exists.

ORA-22306: type “string”.”string” already exists
Cause: The user is trying to create a type that already exists.
Action: Check to make sure that the type has not been created prior to this.
ORA-22307: operation must be on a user-defined type
Cause: attempt to perform an operation that is allowed only on a user-defined type, and the type is not a user-defined type.
Action: Check to make sure that only user-defined types are being operated on.
ORA-22308: operation not allowed on evolved type
Cause: An attempt was made to replace a type whose attribute definition been been altered.
Action: Submit ALTER TYPE ADD/DROP statement instead of ALTER TYPE REPLACE.

ORA-22309: attribute with name “string” already exists
Cause: The user is attempting to create an object type where more than one attributes have the same name.
Action: Check to make sure that all attribute names are unique.
ORA-22310: ALTER TYPE error. Refer to table “string”.”string” for errors
Cause: An invalid alter type statement was submitted.
Action: Correct the errors listed in specified table and resubmit statement.
ORA-22311: type for attribute “string” does not exist
Cause: The type of the attribute does not exist.
Action: No 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.
ORA-22312: must specify either CASCADE or INVALIDATE option
Cause: An attempt was made to alter a type which has a dependent type or table without specifying the CASCADE or INVALIDATE option.
Action: Resubmit the statement with either the CASCADE or INVALIDATE option. Specify CASCADE if you want to cascade the type change to dependent types and tables; otherwise, specify INVALIDATE to invalidate all dependents.

Above are list of Oracle Database Errors or Warnings from Error ORA-22303 to ORA-22312 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.

Thanks,
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 *