DELIMITER//

CREATE PROCEDURE add(
    IN a INT,
    IN b INT
)
BEGIN
    DECLARE sol INT;

    SET sol = num1 + num2;

    SELECT sol AS Sum;
END //

DELIMITER ;

CALL add(10, 20);