TRIGGER: SYSTEM.DEF$_PROPAGATOR_TRIG

Source

Description

system.def$_propagator_trig
  BEFORE INSERT ON system.def$_propagator

Type

BEFORE STATEMENT

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
  prop_count  NUMBER;
BEGIN
  SELECT count(*) into prop_count
    FROM system.def$_propagator;

  IF (prop_count > 0) THEN
    -- Raise duplicate propagator error
    sys.dbms_sys_error.raise_system_error(-23394);
  END IF;
END;