CREATE OR REPLACE TRIGGER Trigger_TauxPart
  AFTER INSERT OR UPDATE OF Taux_participe ON PARTICIPE
  FOR EACH ROW
  DECLARE
  sumTaux NUMBER;
BEGIN
  SELECT COUNT(*) INTO sumTaux
  FROM (SELECT Pers FROM PARTICIPE
  GROUP BY Pers HAVING SUM(Taux_participe) > 100);
  IF (sumTaux > 0)
    THEN
      BEGIN RAISE_APPLICATION_ERROR(-20011, 'Taux de participation incorrecte');
    END;
  END IF;
END;
/