All errors › PLS errors
PLS-00642: Local collection types not allowed in SQL statements
What it means
A collection type declared inside PL/SQL (before 12c) was used in SQL with TABLE().
How to fix it
Create the type at schema level (CREATE TYPE ... AS TABLE OF) or upgrade to 12c+ for package-level types.
Catch it before it runs
ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Nearby errors
Updated 2026-11-12.