All errors › ORA errors
ORA-01400: Cannot insert NULL into (column)
What it means
An INSERT left a NOT NULL column empty, either explicitly with NULL or by omitting a column that has no DEFAULT.
How to fix it
Provide the value, add a DEFAULT (or DEFAULT ON NULL) to the column, or fill it in a trigger. The message names the schema, table and column.
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.