[Home] [Help]
TRIGGER: MDSYS.OGIS_CRS_DELETE_TRIGGER
Source
Description
MDSYS.OGIS_CRS_DELETE_TRIGGER
BEFORE
DELETE
ON
MDSYS.ogis_spatial_reference_systems
FOR EACH ROW
Type
BEFORE EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
DELETE FROM MDSYS.sdo_coord_ref_system WHERE SRID = :old.srid;
END;