ORA-01400 🗃️ SQL

ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN")

A NULL was inserted into a NOT NULL column.

Seen on: SQL

Meaning

Missing values, identity/sequence not wired up, or an empty string ('' is NULL in Oracle).

Common causes

  • Missing required value
  • Empty string treated as NULL
  • Id column without sequence/identity default

⚡ Quick fix

  1. Provide values
  2. Use identity columns or sequence defaults
  3. Remember '' = NULL in Oracle

Detailed fix by platform

SQL

  1. ALTER TABLE orders MODIFY (id DEFAULT orders_seq.NEXTVAL);

How to diagnose

  1. Column — Named in the message
  2. Value — Empty string?

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.