Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Update of Raw data? using 9.2
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
![]() |
![]() |