CREATE PROCEDURE `ewtr`(IN resLabel VARCHAR(255), OUT r INT, OUT w INT, OUT x INT) READS SQL DATA BEGIN DECLARE ra, wa,xa INT; DECLARE rd, wd, xd INT; DECLARE eof INT; ra = NULL; wa = NULL; 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 ra = rd; END IF; IF wd IS NOT NULL; THEN wa = rd; END IF; IF xd IS NOT NULL; THEN xa = rd; END IF; UNTIL eof=1; END REPEAT; CLOSE permChain; SET r = ra; SET w = wa; SET x = xa; END