return result set in SPs

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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?

and another question: is MyODBC 3.51 tested with MySQL 5.x? can we
call an SP from Delphi via MyODBC? (i tried to do so (using ADO an a
data provider for OLEDB) but i think somewhere in passing the call
statement it had put {} around "call sp()" statement so that mysql
returned an error about the syntax.)

Thanks in advane

Posted using the interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL:
Visit Topic URL to contact author (reg. req'd).  Report abuse:

Re: return result set in SPs

Chagh wrote:
Quoted text here. Click to load it

Yes.  See example in user comment on this page:

Bill K.

Site Timeline