Stored Procedure: Creating and using

CREATE PROCEDURE GetEmployeeDetails (IN empID INT)
BEGIN 
SELECT * FROM Employees WHERE EmployeeID = empID; 
END;

CALL GetEmployeeDetails(101);