Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-32005: error while parsing size specification [string]

1 Answers  


ORA-16110: user procedure processing of logical standby apply DDL

1 Answers  


ORA-30196: reserved for future use

1 Answers  


PCC-01010: Invalid use of NULL character in character literal

1 Answers  


ORA-16788: Unable to set one or more database configuration property values

1 Answers  






NNL-00400: Response status:

1 Answers  


ORA-12537: TNS:connection closed

2 Answers   State Bank Of India SBI,


PCC-02407: Object and REF types do not match

1 Answers  


ORA-30754: column or table string stores objects of only one type

1 Answers  


ORA-29815: object being associated is not present

1 Answers  


SQL*Loader-00511: Unable to initialize read functions

1 Answers  


ORA-32763: Turn off N-Pass Temp LOB cleanup

1 Answers  






Categories