MySQL Forums
Forum List  »  Stored Procedures

When will store procedure/functions support result set as return type
Posted by: bruno QUIN
Date: February 26, 2015 04:20AM

I have noticed that MySql doesn't support result-set on a store procedure and functions, which means return a table.

So I can't do things like

CALL sp_my_store_procedure() ORDER BY id ASC;

Or

CALL sp_my_store_procedure() WHERE id = 10;

However I can run select on the store procedure and get the results on another language like php, java, etc, but that's not the same as returning a table.

I mean having mysql without returning tables is more and less the same as running a method in php and instead of using return, use echo.

So I wondering if does anyone know which future version of mysql will support that?

Options: ReplyQuote


Subject
Views
Written By
Posted
When will store procedure/functions support result set as return type
2960
February 26, 2015 04:20AM


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.