Default Value
From: web.Hunter <alberto.ceriotti_at_gmail.com>
Date: Sat, 29 Mar 2008 07:32:57 -0700 (PDT)
Message-ID: <8cc7239f-9e10-4fe0-9c94-b85f0cca31a6@d21g2000prf.googlegroups.com>
Date: Sat, 29 Mar 2008 07:32:57 -0700 (PDT)
Message-ID: <8cc7239f-9e10-4fe0-9c94-b85f0cca31a6@d21g2000prf.googlegroups.com>
Hi, I've a problem with default value of integer data type: my
software work fine with oracle version 8, but fail with 11g version.
The problem is on sql insert command because are often omitted some
columns for use the default value. If the column omitted has a integer
data type, on oracle 8 the command is succesful executed; viceversa
the command faild on 11g oracle version: the response message return
an unexpected null value on a not-null column. I repeat: Only on
integer data type column.
I suppose that there is a configuration value that is possible to modified but I don't know what and here.
Thanks
Best Regards
Received on Sat Mar 29 2008 - 09:32:57 CDT