Members   Search      Help    Register    Login    Home
Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01400:cannot insert NULL into columns(oracle10g,unix,)
ORA-01400:cannot insert NULL into columns [message #474164] Fri, 03 September 2010 05:28 Go to next message
balaji14
Messages: 235
Registered: September 2006
Location: india
Senior Member
Hi ,


i am getting following error while trying to insert value into columns of table.

ORA-01400: cannot insert NULL into ("demo"."col1"."col2")

Thanks

Report message to a moderator

Re: ORA-01400:cannot insert NULL into columns [message #474165 is a reply to message #474164] Fri, 03 September 2010 05:33 Go to previous messageGo to next message
sujeethkannan
Messages: 10
Registered: August 2010
Location: CHENNAI
Junior Member
You are trying to insert a null value in not null column. becuase of that error is arriving..Check the ddl of hte table creation to make sure that..

thanks,
kannan

Report message to a moderator

Re: ORA-01400:cannot insert NULL into columns [message #474168 is a reply to message #474165] Fri, 03 September 2010 06:16 Go to previous message
balaji14
Messages: 235
Registered: September 2006
Location: india
Senior Member
THank you

Report message to a moderator

Previous Topic:Table comparision
Next Topic:ORA-22813: operand value exceeds system limits
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 04 01:39:10 CST 2012

Total time taken to generate the page: 0.51915 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.