created a view using cast(multiset...), why is the view NOT updatable?
683568Mar 5 2009 — edited Mar 10 2009i created a view as follows:
CREATE OR REPLACE FORCE VIEW "MYDB"."VW_TEST" ("TNAME", "CODELIST") AS
select q1.tname,
cast (multiset (SELECT cCode, vDescription, vAbbrev
FROM MYTABLE where q1.tname = q2.tname) as codeList_tbl) codeList
from
(select tname from col where cname = 'CCODE' and tname like 'CD%') q1,
(select tname from col where cname = 'VDESCRIPTION' and tname like 'CD%') q2
where q1.tname = q2.tname;
resulting view is not updatable
but according to
Oracle® Database Application Developer's Guide - Fundamentals
10g Release 2 (10.2)
Chapter 9 Coding Triggers
subsection: Triggers on Nested Table View Columns
i can create an INSTEAD-OF trigger over the codeList column but the column is not updatable ?!?
please help
thank you