TRIGGER: MDSYS.SDO_TOPO_TRIG_INS1

Source

Description

SDO_TOPO_TRIG_INS1
INSTEAD OF INSERT ON SDO_TOPO_TRANSACT_DATA$
REFERENCING NEW AS n
FOR EACH ROW

Type

INSTEAD OF

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS N OLD AS OLD

Body

declare
begin

   INSERT INTO SDO_TOPO_TRANSACT_DATA
      values(SDO_TOPO_TRANSACT_SUBSEQ.nextval, :n.topology_id, :n.topo_id,
                :n.topo_type, :n.topo_op, :n.parent_id);

end;