MySQL Forums
Forum List  »  Stored Procedures

URGENT: return result set in SPs
Posted by: Chagh
Date: August 21, 2005 07:24AM

hi all,
how can we have a select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server to MySQL and i don't know what to do with these SPs. :(
it can be done in MySQL client, but it gives the error:"procedure foo can't return a result set in the given context MySQL"
in the application.
can i set a cursor out put parameter and return it?(just like Oracle) or it has another solution?

Thanks in advane
Chagh

Options: ReplyQuote


Subject
Views
Written By
Posted
URGENT: return result set in SPs
4585
August 21, 2005 07:24AM
3611
August 22, 2005 02:54AM
6193
August 28, 2005 09:39PM


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.