All Oracle errors
ORA-06502plsql

PL/SQL numeric or value error

ORA-06502: PL/SQL: numeric or value error

Why it happens

An assignment overflowed a variable — too many characters for a VARCHAR/CHAR, a number too big for NUMBER(a), or a NULL converted to a non-NULL type.

How to fix it

Enlarge the variable, use %TYPE/%ROWTYPE so sizes match the table columns, or CAST explicit lengths. DBMS_OUTPUT gives you the exact line in the stack trace.

A note on ORA-06502

This entry is part of a hand-curated set of ORA-, FRM-, REP- and TNS- codes that actually turn up in production Oracle estates — SQL*Plus, APEX, 19c/21c, ODP.NET apps, Oracle Forms 6i/12c and Reports included. The message text above is the canonical wording; the cause and fix are written in plain language so a developer or DBA can act without digging through pages of Oracle reference docs first.

Codes outside this list of 44 are far less common. If you hit one, the official Oracle error reference and your instance's alert or listener log remain the authoritative source.

Related plsql errors

ORA-01403 · No data found ORA-04091 · Table is mutating ORA-06550 · PL/SQL line/column error

Build custom software with us

From internal tools to full platforms — we deliver end to end.

Start a Project
Was this tool useful?