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


Subject
Views
Written By
Posted
2199
September 05, 2013 03:36AM
1397
September 06, 2013 08:25AM
Re: returning multiple rows from procedure
3282
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.