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 -> Update of Raw data? using 9.2

Update of Raw data? using 9.2

From: mrmr <guitarzealot_at_yahoo.com>
Date: 18 Oct 2006 17:48:36 -0700
Message-ID: <1161218916.910911.190940@k70g2000cwa.googlegroups.com>


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. What can this be?  If I select from the table with validation_status is null I get no rows back
so the table really doen't have nulls in that column.

update modn.mn_sale rev

   set (rev.INV_QTY , rev.validation_status)

Thanks Received on Wed Oct 18 2006 - 19:48:36 CDT

Original text of this message

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