Re: This Update doesn't work ... Why?

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Wed, 10 Apr 2002 15:08:00 GMT
Message-ID: <3CB4554C.F12A7952@exesolutions.com>

It would be very helpful if you had included things like the version and the text with ORA-904. But just looking quickly at your statement ... I am wondering what the point of "J" is?

Daniel Morgan

"Lío" wrote:

> 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 - 10:08:00 CDT