ORA-01401: inserted value too large for column
An older form of the 'value too large' error: a value was longer than its column. Current releases normally report ORA-12899 with the column name.
- Error code
ORA-01401- Category
- Data values and conversion
What it means
ORA-01401 means a value inserted or updated was larger than the column could hold. Modern Oracle releases usually raise ORA-12899 instead, which names the column and the lengths, so ORA-01401 now mostly appears from older versions or specific code paths.
Common causes
- A string longer than the column's defined length.
- Multi-byte characters in a column sized in bytes.
How to fix it
-
Compare the data with the column sizes and widen the column, as for ORA-12899.
ALTER TABLE customers MODIFY (name VARCHAR2(200 CHAR));
Related errors
More data values and conversion errors
ORA-01722invalid numberORA-00932inconsistent datatypesORA-01476divisor is equal to zeroORA-01843not a valid monthORA-01861literal does not match format stringORA-01830date format picture ends before end of input
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
Work on Oracle in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.