Re: Another newbie question about UPDATE

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 26 May 2005 09:56:01 -0700
Message-ID: <1117126561.399097.105460@o13g2000cwo.googlegroups.com>

Ole Hansen wrote:
> Hi !
>
> Another question from this stupid danish oracle-newbie :-)
>
> I have 2 tables, STOCKTABLE and STOCKTABLE_EXT
>
> I want to update 2 fields in STOCKTABLE, with the values of 2 fields
> in STOCKTABLE_EXT.
>

[]
> I have tried:
>
> UPDATE STOCKTABLE st
> SET (st.ItemName, st.ItemGroup) =
> (SELECT ste.ItemName, ste.ItemGroup
> FROM STOCKTABLE_EXT ste
> WHERE st.itemnumber = ste.itemnumber)
>
> But i get an ORA-01407 "Cannot update STOCKTABLE.ItemName to NULL".
>
> So obviously there is something wrong with my statement. What am i
> doing wrong ?

Given that error message why do you think the problem is in your statement? I would first look in the data. Is there a row (or many) in STOCKTABLE_EXT that has a NULL ItemName??

Ed
Two proverbs:
1. Sometimes it doesn't pay to overlook the obvious. 2. Know your data. Received on Thu May 26 2005 - 11:56:01 CDT