[Solved] Execute Stored Procedure with Output Parameter in MySql database

I have created the following simple Stored Procedure with Output Parameter.

DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `DisplayName`(_Name VARCHAR(100), OUT _OutName VARCHAR(100))
BEGIN
		SET _OutName = _Name;
END

Now to call this procedure and get the Output Parameter value we will need to create a variable.

set @Name:= '';
CALL `northwind`.`DisplayName`('Mudassar Khan', @Name);
SELECT @Name