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

TNS-01113: save_config_on_stop can either be ON or OFF

1 Answers  


DRG-50701: error in listener.get_cmd()

1 Answers  


RMAN-06732: database dropped

1 Answers  


PCB-00501: Runtime context variable "string" not of correct type

1 Answers  


ORA-15006: template "string" does not exist

1 Answers  






LRM-00105: 'string' is not a legal Boolean for 'string'

1 Answers  


LFI-00104: Read operation failed.

1 Answers  


ORA-15131: block string of file string in diskgroup string could not be read

1 Answers  


ORA-06557: null values are not allowed for any parameters to pipe icd's

1 Answers  


DRG-13312: user CTXSYS does not own USER_LEXER stored procedure string

1 Answers  


ORA-01621: cannot rename member of current log if database is open

1 Answers  


IMP-00048: mismatched file header

1 Answers  


Categories