DECLARE
  PROCEDURE UpdateStudents (iloscPrzedmiotow NUMBER) IS
    CURSOR egzaminyCursor (studentId NUMBER) IS SELECT
      COUNT(*) AS egzaminyCount FROM EGZAMINY e WHERE e.ID_STUDENT = studentId AND e.ZDAL = 'Y';
    CURSOR studentCursor IS SELECT *
                            FROM STUDENCI;
    zmiennaCount NUMBER;
    lastDate DATE;
    BEGIN
      FOR student IN studentCursor LOOP
        OPEN egzaminyCursor(student.ID_STUDENT);
        FETCH egzaminyCursor INTO zmiennaCount;
        CLOSE egzaminyCursor;
        IF zmiennaCount > iloscPrzedmiotow THEN
          SELECT MAX(e.DATA_EGZ) INTO lastDate FROM EGZAMINY e WHERE e.ID_STUDENT = student.ID_STUDENT AND e.ZDAL = 'Y';
          UPDATE STUDENCI SET NR_ECDL = student.ID_STUDENT, DATA_ECDL = lastDate WHERE ID_STUDENT = student.ID_STUDENT;
        END IF;
      END LOOP;
    END UpdateStudents ;
  BEGIN
 UpdateStudents(5);
END;