Mine

CREATE PROCEDURE `erew`(IN resLabel VARCHAR(255), OUT rp INT, OUT wp INT, OUT xp INT)
    READS SQL DATA
BEGIN
	DECLARE ra, wa,xa INT;
	DECLARE rd, wd, xd INT;
	DECLARE eof INT;
	SET ra = NULL;
	SET wa = NULL;
	SET xa = NULL;
	DECLARE permChain CURSOR FOR SELECT r, w, x FROM Privtemp ORDER BY id;
	DECLARE CONTINUE HANDLER FOR NOT FOUND SET eof = 1;
	OPEN permChain;
	REPEAT
		FETCH permChain INTO rd, wd, xd;
		IF rd IS NOT NULL;
		THEN SET ra = rd;
		END IF;
		IF wd IS NOT NULL;
		THEN SET wa = rd;
		END IF;
		IF xd IS NOT NULL;
		THEN SET xa = rd;
		END IF;
	UNTIL eof=1 END REPEAT;
	CLOSE permChain;
	SET rp = ra;
	SET wp = wa;
	SET xp = xa;
END