Re: returning multiple rows from procedure
> 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)
Subject
Views
Written By
Posted
2199
September 05, 2013 03:36AM
1397
September 06, 2013 08:25AM
1191
October 05, 2013 06:32AM
1197
October 10, 2013 09:40PM
1473
September 07, 2013 07:25PM
Re: returning multiple rows from procedure
3282
October 15, 2013 03:42PM
1211
October 16, 2013 09:28AM
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.