Oracle Solution for Error ora-22343

Solution for Oracle Error ORA-22343

ORA-22343: Compilation error for type invalidated by ALTER TYPE

What triggered the Error:

mpilation failed for a type which was invalidated by ALTER TYPE. We throw this error and rollback the compilation effort so that the user may be able to fix whatever is causing the compilation error and try again. It is important that we do not chnage status here and modify the dependency information as this will affect the creation of versions.

What should we do to fix it:

eck what is causing teh compilation error and correct it and try again.