-- set the delimiter to '//' because we use ';' in the procedure body WARNINGS DELIMITER // -- drop it before we try to create it so we don't get an error when -- updating the procedure later on DROP PROCEDURE IF EXISTS getColour// CREATE PROCEDURE getColour() BEGIN DECLARE l_retVal INT; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN SELECT l_retVal; END; DECLARE CONTINUE HANDLER FOR NOT FOUND BEGIN SELECT l_retVal; END; DECLARE CONTINUE HANDLER FOR SQLWARNING BEGIN SELECT l_retVal; END; SET l_retVal = -2; SELECT * FROM Coins; SET l_retVal = -1; SELECT * FROM Coins WHERE Value > 20; SET l_retVal = 0; SELECT l_retVal; END// -- reset the delimiter to ';' DELIMITER ;