MySQL Forums
Forum List  »  Stored Procedures

Re: returning multiple rows from procedure
Posted by: Peter Brawley
Date: October 15, 2013 03:42PM

> return multiple rows as out parameter in procedure like in oracle ref_cursor\array

MySQL does not implement either arrays or resultsets as datatypes, so the only ways to return multiple rows in an OUT param are ..

(i) put the resultset in a temporary table, and put the name of that table in the OUT param

(ii) build a string of concatenated row data values (but if you build it in csv format, you might as well send it back as as a csv table)

Options: ReplyQuote

Written By
September 05, 2013 03:36AM
September 06, 2013 08:25AM
Re: returning multiple rows from procedure
October 15, 2013 03:42PM

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.