CheckStaff

CREATE OR REPLACE FUNCTION CheckStaff(p_idUser "User".idUser%TYPE, p_idTrainRide trainride.idtrainride%TYPE)
RETURN BOOLEAN
AS
  isNull BOOLEAN;
BEGIN
  FOR pRow IN (SELECT * FROM  Reservation WHERE iduser = p_iduser AND idtrainride = p_idTrainRide)
    LOOP
      IF (pRow.confirm IS NOT NULL) THEN
        isNull := FALSE;
      ELSE
        isNull := TRUE;
      END IF;
    END LOOP;
    IF (isNull) THEN
      RETURN FALSE;
    ELSE
      RETURN TRUE;
   END IF;
END;

SET serveroutput ON;
BEGIN
  IF (CheckStaff('1','1')) THEN
    DBMS_OUTPUT.put_line('true');
  ELSE
    DBMS_OUTPUT.put_line('false');
  END IF;
END;