All errors › ORA errors
ORA-06502: PL/SQL: numeric or value error
What it means
A value does not fit a PL/SQL variable: string longer than the VARCHAR2 size (character string buffer too small), number out of range or precision, NULL assigned to a NOT NULL variable, or a string-to-number conversion failure.
How to fix it
Read the suffix of the message (character string buffer too small / character to number conversion error / number precision too large). Declare variables with %TYPE so they follow the column size, and remember VARCHAR2 sizes default to BYTE semantics with multi-byte character sets.
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.