| View previous topic :: View next topic |
| Author |
Message |
vj.jain Site Admin
Joined: 10 Aug 2007 Posts: 86
|
Posted: Tue Apr 14, 2009 5:29 pm Post subject: ORA-01400 cannot insert NULL into |
|
|
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. |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Sponsored by
Oracle Consulting
Copyright ©2007
Oracle-Developer.com
|