Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01400: cannot insert NULL into ??? Problem with 'int'?

ORA-01400: cannot insert NULL into ??? Problem with 'int'?

From: Rich D <rdalfonso_at_nyc.rr.com>
Date: 24 Nov 2002 12:20:41 -0800
Message-ID: <196cd325.0211241220.4227e67c@posting.google.com> 





I seem to be getting a problem whenever I do an insert. It happens if
the datatype of the column is 'int' or 'number' or 'numeric'.



The error I get is :


ORA-01400: cannot insert NULL into


("SYSTEM"."My_TABLE_NAME"."INTEGER_COLUMN")



If I alter the table and change the columns datatype to char it works.
Why does this error always happen on fields that are 'int' or
'number'?



Its driving me crazy.



Am I using the wrong datatype for Oracle?
Received on Sun Nov 24 2002 - 14:20:41 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US