Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-22346 – Type has cyclical dependency. Should use CASCADE option

Oracle Database Error Code ORA-22346 Description :

Type has cyclical dependency. Should use CASCADE option

Error Cause:

An attempt was made to alter a type which has a cyclical dependency, with invalidate option.

How to Solve :

Give CASCADE option instead of INVALIDATE