MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Best way to "CALL ... INTO @a, @b"?
Posted by: Jarno Elonen
Date: March 17, 2013 07:04AM

Hi!

Unlike "SELECT ... INTO @a, @b", a syntax such as "CALL ... INTO @a, @b" does not work.
Apart from rewriting the procedures to store the results in OUT/INOUT variables, what are the preferred ways to extract data from their resultsets into local variables?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Best way to "CALL ... INTO @a, @b"?
2149
Jarno Elonen
March 17, 2013 07:04AM
Re: Best way to "CALL ... INTO @a, @b"?
1245
Peter Brawley
March 17, 2013 08:48AM
Re: Best way to "CALL ... INTO @a, @b"?
2099
Jarno Elonen
March 17, 2013 10:13AM
Re: Best way to "CALL ... INTO @a, @b"?
1114
Peter Brawley
March 20, 2013 10:33AM


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.