Oracle Error ORA-22312: must specify either CASCADE or INVALIDATE option

Oracle Error Message

ORA-22312: must specify either CASCADE or INVALIDATE option

Reason for the Error

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.