CREATE OR REPLACE
 PROCEDURE findTruck(ID_Kier IN NUMBER)
 IS
 BEGIN
  DECLARE
 i NUMBER;
 truckAmount NUMBER;
 truckID VARCHAR2(8);
 truckStatus VARCHAR2(12);
 CURSOR get_current_amount_trucks IS SELECT COUNT(NUMER_REJESTRACYJNY) FROM samochod;

BEGIN
  OPEN get_current_amount_trucks;
  FETCH get_current_amount_trucks INTO truckAmount;
  CLOSE get_current_amount_trucks;
  i:=1;

  WHILE (i < truckAmount+1)
  LOOP
    SELECT Status INTO truckStatus FROM Samochod WHERE ID_SAMOCHOD = i;
      IF(truckStatus='Dostepny')THEN
        SELECT NUMER_REJESTRACYJNY INTO truckID FROM Samochod WHERE ID_SAMOCHOD = i;
        EXIT;
      END IF;
    i:=i+1;
  END LOOP;

  INSERT INTO DOSTAWA(ID_Dostawy,Planowany_Czas_Wyjazdu,Czas_Wyjazdu,Wartosc_Dostawy,Waga_Dostawy,Numer_Rejestracyjny,Status,ID_Kierowcy)
  VALUES(NULL,NULL,NULL,NULL,NULL,truckID,DEFAULT,ID_Kier);

 END;
 END;