Xgc: thanks. so id do something like (in trigger) CREATE TRIGGER ioftX INSTEAD OF INSERT ON vMyView FOR EACH ROW DECLARE x NUMBER; BEGIN; insert into y values (1, 2) returning rowid into x; insert into z values (3, 4); UPDATE ... ; etc..; END ioftX; ..
so what mechanism would i be able to go insert into vMyView values (5, 6) returning rowid into z; ?
to get x from the trig into z outside
hmm. i just saw something about :new.Result
maybe the insert for which i want the rowid can be stored into :NEW.RESULT ?
and that could be used by "returning rowid" from calling blocks?