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.

Error Type: ORA

• Additional information for ORA-22312: must specify either CASCADE or INVALIDATE option22312
Discussions and solutions for Oracle Database Error ORA-22312: must specify either CASCADE or INVALIDATE option Developer anwers for Oracle Database Error ORA-22312: must specify either CASCADE or INVALIDATE option FAQs for ORA-22312: must specify either CASCADE or INVALIDATE option search others tips for ORA-22312: must specify either CASCADE or INVALIDATE option