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

NNL-00996: OK responses received: number

1 Answers  


ORA-00965: column aliases not allowed for '*'

1 Answers  


ORA-38720: Missing log file number.

1 Answers  


ORA-35587: (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number levels.

1 Answers  


DRG-11442: valid gist numParagraphs values are string

1 Answers  


PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 Answers  


ORA-09208: sftcls: error closing file

1 Answers  


ORA-07552: sftget: $GET failure

1 Answers  


DRG-10846: order by columns must be all ascending or all descending

1 Answers  


PROT-00304: Failed to create dump file

1 Answers  


ORA-30503: system triggers cannot have a REFERENCING clause

1 Answers  


ORA-12170: TNS:Connect timeout occurred

1 Answers  


Categories