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
2660
September 05, 2013 03:36AM
1596
September 06, 2013 08:25AM
1373
October 05, 2013 06:32AM
1402
October 10, 2013 09:40PM
1680
September 07, 2013 07:25PM
Re: returning multiple rows from procedure
3673
October 15, 2013 03:42PM
1393
October 16, 2013 09:28AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.