| 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")
See also other Oracle errors.
|