Oracle Solution for Error ora-22312

ORA-22312: must specify either CASCADE or INVALIDATE option

What triggered the Error:

attempt was made to alter a type which has a dependent type or table without specifying the CASCADE or INVALIDATE option.

What should we do to fix it:

submit 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.