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



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

Answer / guest

Cause: Compilation 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.

Action: Check what is causing teh compilation error and
correct it and try again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

IMG-00580: specified format does not support output

1 Answers  


ORA-09885: osnTXtt: cannot create TXIPC channel

1 Answers  


ORA-12217: TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA

1 Answers  


ORA-23397: global name "string" does not match database link name "string"

1 Answers  


ORA-16515: no rcv channel

1 Answers  






RMAN-06058: a current controlfile cannot be included along with a standby controlfile

1 Answers  


DRG-10817: CONTAINS term consists of stopword or phrase of stopwords: string

1 Answers  


ORA-12432: LBAC error: string

1 Answers  


PLS-00213: package STANDARD not accessible

1 Answers  


O2F-00303: No INTYPE file was specified

1 Answers  


ORA-19032: Expected XML tag string got string

1 Answers  


LPX-00259: invalid notation declaration

1 Answers  


Categories