All errors › ORA errors
ORA-00902: Invalid datatype
What it means
A column or CAST uses a type name Oracle does not know (BOOLEAN in tables before 23ai, TEXT, DATETIME, INT UNSIGNED...).
How to fix it
Use Oracle types: VARCHAR2, NUMBER, DATE, TIMESTAMP, CLOB, BLOB; NUMBER(1) or CHAR(1) for flags before 23ai.
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.