DAIS_5

CREATE OR REPLACE
TRIGGER checkTrainCrew
AFTER INSERT OR UPDATE
ON TrainCrew
DECLARE

CURSOR cursS IS SELECT * FROM Staff;
CURSOR cursTC IS SELECT * FROM TrainCrew WHERE idTrainRide = NEW.idTrainRide;

sc INT;
dc INT;
gc INT;

BEGIN
sc := 0;
dc := 0;
gc := 0;

  FOR cS IN cursS LOOP
    FOR cTC IN cursTC LOOP
      IF(cS.idStaff = cTC.idStaff) THEN

        IF(cs.position = 's') THEN
          sc := sc + 1;
        END IF;

        IF(cs.position = 'g') THEN
          gc := gc + 1;
        END IF;

        IF(cs.position = 'd') THEN
          dc := dc + 1;
        END IF;

      END IF;
    END LOOP;
  END LOOP;
END;