PLS-00642: local collection types not allowed in SQL statements
- 1 Answers
- 7981 Views
- I also Faced
- E-Mail Answers
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 |
ORA-32005: error while parsing size specification [string]
ORA-16110: user procedure processing of logical standby apply DDL
ORA-30196: reserved for future use
PCC-01010: Invalid use of NULL character in character literal
ORA-16788: Unable to set one or more database configuration property values
NNL-00400: Response status:
ORA-12537: TNS:connection closed
2 Answers State Bank Of India SBI,
PCC-02407: Object and REF types do not match
ORA-30754: column or table string stores objects of only one type
ORA-29815: object being associated is not present
SQL*Loader-00511: Unable to initialize read functions
ORA-32763: Turn off N-Pass Temp LOB cleanup
Oracle Errors 
