The following is the ORA-22312 error message, you can learn the cause and solution of the Oracle database error.
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.
Solution: 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.
Please wait for the update…