Stored Procedures with Multiple Result Sets

[Prasad Kawade]

Hi,
I am new to MySQL. Please help me with below query.

CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_RetrieveData`()
BEGIN

SELECT E_ID, E_NAME, E_DEPTNAME FROM EMPLOYEE;

SELECT DEPT_ID, DEPT_NAME FROM DEPARTMENT;

SELECT S_ID, S_NAME, S_ADDRESS FROM S_DATA;

END;

How can I retrieve multiple result sets in OUTPUT Parameters ?

Thanks.