TRIGGER: MDSYS.SDO_GEOM_TRIG_DEL1

Source

Description

SDO_GEOM_TRIG_DEL1
INSTEAD OF DELETE ON user_sdo_geom_metadata
REFERENCING OLD AS n
FOR EACH ROW

Type

INSTEAD OF

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS N

Body

declare
BEGIN

  mdsys.sdo_meta.delete_all_sdo_geom_metadata(user,
                                              :n.table_name,
                                              :n.column_name);

END;