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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Update of Raw data? using 9.2

Re: Update of Raw data? using 9.2

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 19 Oct 2006 04:38:49 -0700
Message-ID: <1161257929.298468.41590@f16g2000cwb.googlegroups.com>

mrmr schreef:

> The columns orig.validation_status and rev.validation_status are
> defined as RAW.
> When I run this update I get a message that says
> ORA-01407: cannot update ("MODN"."MN_SALE"."VALIDATION_STATUS") to NULL
>
> But the column is defined as nullable no.

You contradict yourself: nullable=NO: cannot be modified to NULL. So the error message is correct Received on Thu Oct 19 2006 - 06:38:49 CDT

Original text of this message

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