ORA Error ReferenceSearch errors

All errors › PLS errors

PLS-00320: The declaration of the type of this expression is incomplete or malformed

What it means

A %TYPE/%ROWTYPE refers to something missing (a column that was dropped/renamed, or a table you cannot see).

How to fix it

Fix the referenced table/column or the privilege.

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.

Nearby errors

Updated 2026-11-12.