DELIMITER $$ CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`travel_checkRaid`( vIsRaid BOOL, vDaysInForward INT ) BEGIN /** * Check if the values of isRaid and daysInforward are correct * * @param vIsRaid idRaid value * @param vDaysInForward daysInForward value */ IF (NOT vIsRaid AND vDaysInForward IS NOT NULL) OR (vIsRaid AND vDaysInForward IS NULL) THEN CALL util.throw('The raid information is not correct'); END IF; END$$ DELIMITER ;