Page 1 of 1

MySQL Stored Procedures

Posted: Tue Mar 23, 2010 1:13 am
by eomer
Good evening,

I am attempting to execute a stored procedure after connecting to a local MySQL database and I get the the following error:

PROCEDURE denovo.Contact_SEL_ByLastName can't return a result set in the given context

According to the documentation at the mysql site, this is because the CLIENT_MULTI_RESULTS flag is not being passed when the connection is established.

http://dev.mysql.com/doc/refman/5.1/en/ ... eries.html

Does anyone here have any experience working with MySQL stored procedures from Revolution? I am hoping there is an answer to this riddle as the database I am working with relies heavily upon stored procedures.

Thank you