CREATE TRIGGER C_Date_D2

BEFORE INSERT OR UPDATE OF Date_Ins ON Liste_Electeur

FOR EACH ROW

DECLARE D1 DATE;

BEGIN

Select Date_d  INTO D1 from Periode;

Select Date_f  INTO D2 from Periode;

IF (new. Date_Ins < D1)

THEN raison_application_error(-99999,'Date de MAJ de Liste d’Inscription erroné')

END IF;

END;