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

ORA-25472: maximum open iterators exceeded

1 Answers  


NCR-03004: NCRO: Unknown message

1 Answers  


PCB-00305: Oracle extension to the COMMIT and ROLLBACK statements

1 Answers  


ORA-00071: process number must be between 1 and string

1 Answers  


DRG-10309: not enough job queue processes

1 Answers  


NNC-00426: no such data type

1 Answers  


DRG-10816: display/highlight call failed

1 Answers  


RMAN-06552: newname for datafile number was set to NEW, but file was not restored

1 Answers  


ORA-07672: $PARSE_CLASS failed translating the string into a binary label

1 Answers  


EXP-00097: Object type "string"."string" is not in a valid state, type will not be exported

2 Answers  


ORA-16540: invalid argument

1 Answers  


LFI-00130: Input option specified on output only file.

1 Answers  


Categories