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-34357: (MXDSS10) string is not an alias of analytic workspace string.

1 Answers  


ORA-23482: column string of "string"."string": object types not allowed.

1 Answers  


ORA-02805: Unable to set handler for SIGTPA

1 Answers  


ORA-26534: collision: tranID number ignored and purged

1 Answers  


ORA-24436: Invalid statement Handle.

1 Answers  






ORA-03283: specified datafile string does not exist

1 Answers  


ORA-29902: error in executing ODCIIndexStart() routine

1 Answers  


ORA-16574: switchover disallowed when required databases are offline

1 Answers  


ORA-02194: event specification syntax error string (minor error string) near 'string'

1 Answers  


ORA-22165: given index [string] must be in the range of 0 to [string]

1 Answers  


TNS-03601: Failed in route information collection

1 Answers  


CLSR-01012: Invalid instance stop mode [string] is specified

1 Answers  


Categories