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
Subject
Views
Written By
Posted
URGENT: return result set in SPs
4585
August 21, 2005 07:24AM
3825
August 21, 2005 03:55PM
3611
August 22, 2005 02:54AM
3463
August 22, 2005 03:56AM
3486
August 28, 2005 11:43AM
3283
August 28, 2005 02:07PM
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.