- Oracle-Developer.com -

Navigation: Home  | Discussion Forums (Get expert advice)  |  Scripts  |  About Us  | Links  | Job Openings  
ORA-01400 cannot insert NULL into
Comment on this Topic


ORA-01400 cannot insert NULL into (string)

Cause: An attempt was made to insert a NULL into the column
"USER"."TABLE"."COLUMN".
For example, if you enter:
connect scott/tiger
create table a (a1 number not null);
insert into a values (null);
Oracle returns:
ORA-01400 cannot insert NULL into ("SCOTT"."A"."A1") : which means you
cannot insert NULL into "SCOTT"."A"."A1".

Action: Retry the operation with a value other than NULL.


Comment on ORA-01400 cannot insert NULL into

 

Owned and Operated by Varun Jain, Inc, an Oracle Consulting Firm

Copyright ©2007 Oracle-Developer.com