René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

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")