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

**Code:** `ORA-01400` · **Category:** SQL · **Seen on:** SQL

A NULL was inserted into a NOT NULL column.

## 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?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/ora-01400-cannot-insert-null)
