In this post, you’ll learn more about the Oracle ErrorORA-22312: must specify either CASCADE or INVALIDATE option with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-22312: must specify either CASCADE or INVALIDATE option
Reason for the Error ORA-22312: must specify either CASCADE or INVALIDATE option
An attempt was made to alter a type which has a dependent type or table without specifying the CASCADE or INVALIDATE option.
How to fix the Error ORA-22312: must specify either CASCADE or INVALIDATE option ?
You can fix this error in Oracle by following the below steps
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.