Hello,
I am currently feeding a Voice Response system from a MySQL database
and it would be a lot less of a hassle if I could use Stored
Procedures that return result sets. Now from a recent post by Peter I
deduced that the latest version of MyODBC (3.5.12) was changed in such
a way that an SP could return a result set.
However: when I try to do this 'at home' I get the error that the
"PROCEDURE cannot return a resultset in the given context". I wrote to
the list and to Peter about this, but either my mail got bounced, or
Peter is just too busy, or my question just too stupid. So I am trying
my luch again, but now with a new post/thread. Has anyone be succesful
in retrieving resultsets from an SP? If so: how did you succeed? Do
you have any pointers?
[My setup: Win2003 Server, MySQL 5.0.15, MyODBC 3.5.12-2 (binary package)]
Regards,
Frank

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.