Re: Stored Procedures retrieving multiple result sets
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.
Subject
Views
Written By
Posted
4997
May 21, 2016 11:17PM
4999
May 21, 2016 11:52PM
1592
May 22, 2016 12:04AM
Re: Stored Procedures retrieving multiple result sets
1369
May 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.