ReservationCount

CREATE OR REPLACE FUNCTION getReservationCount(p_idUser "User".idUser%TYPE)
RETURN INTEGER
AS
  v_pocet_rezervacii INTEGER;
BEGIN
  SELECT COUNT(*) INTO v_pocet_rezervacii FROM Reservation WHERE idUser = p_idUser;
  RETURN v_pocet_rezervacii;
END getReservationCount;


SET serveroutput ON;
BEGIN
  DBMS_OUTPUT.put_line(getreservationcount('1'));
END;


CREATE OR REPLACE PROCEDURE InsertReservation(p_idUser "User".idUser%TYPE)
AS
  v_max_pocet_rezervacii INTEGER;
BEGIN
  SELECT maxactivereservationcount INTO v_max_pocet_rezervacii FROM "User" WHERE idUser = p_iduser;
  IF (getReservationCount(p_idUser) < v_max_pocet_rezervacii) THEN
    DBMS_OUTPUT.put_line('User moze vlozit dalsie rezervacie');
  ELSE
    DBMS_OUTPUT.put_line('User nemoze vlozit dalsie rezervacie');
  END IF;
END;