MySQL Forums :: Stored Procedures :: Stored Procedures with Multiple Result Sets


Advanced Search

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 3049 Prasad Kawade 05/22/2016 07:07AM
Re: Stored Procedures with Multiple Result Sets 399 Peter Brawley 05/22/2016 11:44AM
Re: Stored Procedures with Multiple Result Sets 418 Rick James 05/24/2016 10:40AM


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.