xdb.xdb_rv_trig INSTEAD OF insert or delete or update
on xdb.resource_view for each row
Type
INSTEAD OF
Event
INSERT OR UPDATE OR DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
begin
if inserting then
xdb_rvtrig_pkg.rvtrig_ins(:new.res, :new.any_path);
end if;
if deleting then
xdb_rvtrig_pkg.rvtrig_del(:old.res, :old.any_path);
end if;
if updating then
xdb_rvtrig_pkg.rvtrig_upd(:old.res, :new.res,
:old.any_path, :new.any_path );
end if;
end;