|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
ORA-01400: cannot insert NULL into <tablename>
This error is thrown if someone tries to insert a null into a column that has a not null constraint.
create table ora_01400 ( foo number not null, bar number not null, baz number not null );
insert into ora_01400 values (1, null, 3);
ERROR at line 1: ORA-01400: cannot insert NULL into ("RENE"."ORA_01400"."BAR")
See also other Oracle errors.