delimiter ;;

CREATE PROCEDURE sp_sum(IN param1 INTEGER, IN param2 INTEGER, OUT param3 INTEGER)
 begin

  /* BODY */
  SET param3 = param1 + param2;

 END;;

 delimiter ;

 SET @result:=0;

call sp_sum(1,3,@result);