MySQL Forums
Forum List  »  Stored Procedures

Stored Procedures with Multiple Result Sets
Posted by: Prasad Kawade
Date: May 22, 2016 07:07AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored Procedures with Multiple Result Sets
3103
May 22, 2016 07:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.