CREATE OR REPLACE PROCEDURE FOOD_VOUCHERS
(p_festival_nr IN food_tickets.festival_nr%TYPE)
AS
BEGIN
  FOR i IN 1..2000 loop
  INSERT INTO food_tickets(food_ticket_nr,prijs,festival_nr)
  VALUES (foodvoucher_seq.NEXTVAL, 40, p_festival_nr);

    INSERT INTO food_tickets(food_ticket_nr,prijs,festival_nr)
  VALUES (foodvoucher_seq.NEXTVAL, 60, p_festival_nr);

    INSERT INTO food_tickets(food_ticket_nr,prijs,festival_nr)
  VALUES (foodvoucher_seq.NEXTVAL, 80,p_festival_nr);

  END loop;

END FOOD_VOUCHERS;

-- Festival max op 1000 zetten
-- transactie nr van food tickers op nullable true zette
--sequence aanmaken die optelt met incementie van 1