PLS-00642: local collection types not allowed in SQL statements



PLS-00642: local collection types not allowed in SQL statements..

Answer / guest

Cause: A locally-defined (i.e. not schema level) collection
type was used in a SQL statement. The type must be defined
in a schema to be accepted in a SQL statement.

Action: Define the collection type in your schema, not
inside a PL/SQL subprogram.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00550: Unable to log on to ORACLE with "string". ORACLE error number: number

1 Answers  


QSM-01129: query has NO_MULTIMV_REWRITE hint

1 Answers  


ORA-28022: cannot grant external roles to global user or role

1 Answers  


IMG-00543: invalid compressionFormat specified

1 Answers  


ORA-12658: ANO service required but TNS version is incompatible

1 Answers  






PLS-00380: functions and procedures are not included in this release of PL/SQL

1 Answers  


ORA-12153: TNS:not connected

1 Answers  


ORA-24786: separated transaction has been completed

1 Answers  


ORA-07621: smscre: illegal redo block size

1 Answers  


ORA-09216: sdnfy: bad value 'string' for parameter string

1 Answers  


ORA-16067: activation identifier mismatch in archive log string

1 Answers  


PCB-00903: Pro*COBOL is unable to initialize its parser function

1 Answers  


Categories