Re: help understanding an ORA-01732 error with inline view
From: Adric Norris <landstander668_at_gmail.com>
Date: Sat, 22 Oct 2011 13:13:22 -0500
Message-ID: <CAJueESrbT0kkvjYySzbsYNXW3k4Y5j0-ac3M1rrFBKGuD++ySg_at_mail.gmail.com>
Yeah, I also tried with a 10g database (on Solaris this time) this morning, with identical results. At this point I strongly suspect that I'm seeing expected behaviour, but am still hoping to find something which documents the restriction and/or explains the underlying reason. Any suggestions for alternate methods of writing that sort of update statement are, of course, very welcome as well.
Date: Sat, 22 Oct 2011 13:13:22 -0500
Message-ID: <CAJueESrbT0kkvjYySzbsYNXW3k4Y5j0-ac3M1rrFBKGuD++ySg_at_mail.gmail.com>
Yeah, I also tried with a 10g database (on Solaris this time) this morning, with identical results. At this point I strongly suspect that I'm seeing expected behaviour, but am still hoping to find something which documents the restriction and/or explains the underlying reason. Any suggestions for alternate methods of writing that sort of update statement are, of course, very welcome as well.
Thanx for checking! :)
On Sat, Oct 22, 2011 at 11:31, Sidney Chen <huanshengchen_at_gmail.com> wrote:
> just test in 10.2.0.4, the update also failed using order by
> i would guess it's the order by make the view unmodifiable, just a guess.
>
> from the note, it did not clarify the the order by clause will make a join
> view unmodifiable
> Updates on VIEWS Based On Joined Tables Fails With ORA-1779 ORA-1732 [ID
> 1015219.4]
>
>
> --
> Regards
> Sidney Chen
>
>
>
-- "I'm too sexy for my code." -Awk Sed Fred -- http://www.freelists.org/webpage/oracle-lReceived on Sat Oct 22 2011 - 13:13:22 CDT