By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,282 Members | 1,569 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,282 IT Pros & Developers. It's quick & easy.

return result set in SPs

P: n/a
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
Chagh

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-return...ict249893.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=865267
Aug 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Chagh wrote:
hi all,
how can we have a select satement in an SP?(i want to return a result
set from the SP).


Yes. See example in user comment on this page:
http://dev.mysql.com/doc/mysql/en/create-procedure.html

Regards,
Bill K.
Aug 25 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.