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

Home -> Community -> Usenet -> c.d.o.server -> This Update doesn't work ... Why?

This Update doesn't work ... Why?

From: Lío <jgonzalezsuareNO_at_SPAMnexo.es>
Date: Wed, 10 Apr 2002 12:07:47 +0200
Message-ID: <4638bucvhmq6t3qva182fl0jbafk1sva21@4ax.com>


I've done an update with this structure (I'll try to make it simple):

Update T1 set (a, b, c) =
Select ... from

   (Select x, y, complex_func(z) "J" from T2 where T2.r = T1.r) alias_t2,

   T3
   Where T3.... = alias_t2.J and T3.... = T1.... etc, etc.   )
Where T1....

This is inside a packaged procedure. It compiles ok, but when I execute, I get a ORA-904 about the T1.r column.

Why is it not visible T1 from the T2 subquery?

Thanks.

--
Julio César Glez Suarez
Xixón, Asturies, Spain
jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)
Received on Wed Apr 10 2002 - 05:07:47 CDT

Original text of this message

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