MySQL Forums
Forum List  »  Stored Procedures

Re: returning multiple rows from procedure
Posted by: Peter Brawley
Date: September 07, 2013 07:25PM

> return multiple rows as out parameter in procedure like in oracle ref_cursor\array can be used.

No arrays in MySQL. One scalar value per param. You could save the resultset in a table whose name you pass to the sproc.

Options: ReplyQuote

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

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.