DBA Data[Home] [Help]

TRIGGER: MDSYS.SDO_CRS_GEOG_SRID_UPDATE

Source

Description
SDO_CRS_GEOG_SRID_UPDATE
AFTER UPDATE OR DELETE ON MDSYS.SDO_CRS_GEOGRAPHIC_PLUS_HEIGHT
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);
END;