Stored Procedure: Advanced stored procedures

DELIMITER //

CREATE PROCEDURE CalculateBonus (IN empID INT, OUT bonus DECIMAL(10,2), INOUT totalSalary DECIMAL(10,2))
BEGIN
    DECLARE baseSalary DECIMAL(10,2);

    -- Retrieve the base salary
    SELECT Salary INTO baseSalary FROM Employees WHERE EmployeeID = empID;

    -- Calculate the bonus as 10% of the base salary
    SET bonus = baseSalary * 0.10;

    -- Add the bonus to the total salary
    SET totalSalary = totalSalary + bonus;
END //

DELIMITER ;

CALL CalculateBonus(101, @bonus, @totalSalary);
SELECT @bonus, @totalSalary;