Re: help understanding an ORA-01732 error with inline view
- From: Adric Norris <landstander668@xxxxxxxxx>
- To: Sidney Chen <huanshengchen@xxxxxxxxx>
- Date: Sat, 22 Oct 2011 13:13:22 -0500
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
