TRIGGER: MDSYS.SDO_GEOM_METADATA_UPDATE

Source

Description

SDO_GEOM_METADATA_UPDATE
AFTER UPDATE OR DELETE ON MDSYS.SDO_GEOM_METADATA_TABLE
FOR EACH ROW

Type

AFTER EACH ROW

Event

UPDATE OR DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
  mdsys.mdprvt_gmd.invalidate_geom_metadata(:old.sdo_owner,
                                            :old.sdo_table_name,
                                            :old.sdo_column_name);
END;