Re: help understanding an ORA-01732 error with inline view
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Sun, 23 Oct 2011 00:31:31 +0800
Message-ID: <CAM_ddu-0D7E8xr_3QeRQJ-k7-r0YToDzA+nx2yyZLPDJDtFccQ_at_mail.gmail.com>
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]
Date: Sun, 23 Oct 2011 00:31:31 +0800
Message-ID: <CAM_ddu-0D7E8xr_3QeRQJ-k7-r0YToDzA+nx2yyZLPDJDtFccQ_at_mail.gmail.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 22 2011 - 11:31:31 CDT