Re: Oracle not null error when using datatype int

One comment and one question
"Rich D" <rdalfonso_at_nyc.rr.com> wrote in message news:196cd325.0211250707.6ae827a9_at_posting.google.com...
> I get an error when I use a database column of datatype 'int' or
> 'number' that has constraint NOT NULL.
> Whenever I attempt an insert it says:
> ORA-01400: cannot insert NULL into
> ("SYSTEM"."TABLE_NAME"."NUMBER_OR_INT_FIELD")
You shouldn't really be using the SYSTEM account to create your objects.

>
> if I change the column 'NUMBER_OR_INT_FIELD' to have a datatype of
> 'char', it works fine.
>
> Any thoughts why this is?

What is your insert statement and what language/tool are you using?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************