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
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
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
Previous Topic:Table comparision
Next Topic:ORA-22813: operand value exceeds system limits
Goto Forum:
  


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 ::.