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