CREATE OR REPLACE procedure test is

DECLARE CURSOR promo IS SELECT * FROM etudiants;

id etudiants.no_etu%TYPE;

BEGIN
	FOR ligne IN promo LOOP
	    UPDATE etudiants SET promotion=12
		WHERE no_etu=id;
	end loop;
end;
/
