// Oracle error reference

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
Error message
inserted value too large for column

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

  1. 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

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

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.