MySQL Forums :: Stored Procedures :: Stored Procedures retrieving multiple result sets


Advanced Search

Re: Stored Procedures retrieving multiple result sets
Posted by: Peter Brawley ()
Date: May 22, 2016 11:43AM

OUT params are scalars, like IN params. MySQL has no resultset datatype.

You could format small resultsets into OUT param strings, but it would e laborious.

All MySQL APIs (Perl, PHP, NET, Java, Python &c) have the functionality I illustrated.

Options: ReplyQuote


Subject Views Written By Posted
Stored Procedures retrieving multiple result sets 2964 Prasad Kawade 05/21/2016 11:17PM
Re: Stored Procedures retrieving multiple result sets 410 Peter Brawley 05/21/2016 11:52PM
Re: Stored Procedures retrieving multiple result sets 384 Prasad Kawade 05/22/2016 12:04AM
Re: Stored Procedures retrieving multiple result sets 416 Peter Brawley 05/22/2016 11:43AM


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.