TRIGGER: MDSYS.SDO_COORD_REF_SRID_UPDATE

Source

Description

SDO_COORD_REF_SRID_UPDATE
AFTER UPDATE OR DELETE ON MDSYS.SDO_COORD_REF_SYS
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_srid.sdo_invalidate_srid_metadata(:old.srid,
                                                 :old.coord_ref_sys_kind);
END;