Re: Default Value

On 29 mar, 16:32, "web.Hunter" <alberto.cerio..._at_gmail.com> wrote:
> 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

Can you reproduce the error when using sqlplus? If so, please post the output along with the table definitions. Received on Sun Mar 30 2008 - 08:54:10 CDT