DBA Data[Home] [Help]

TRIGGER: MDSYS.SDO_FEATURE_USAGE_UPDATE

Source

Description
SDO_FEATURE_USAGE_UPDATE
AFTER UPDATE OR DELETE ON MDSYS.SDO_FEATURE_USAGE
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_feature.sdo_invalidate_feature(:old.feature_name);
END;