MySQL Forums
Forum List  »  Delphi

PROCEDURE xxx.yyy can't return a result set in the given context.
Posted by: carlos malpica
Date: July 12, 2006 03:43PM

Hello friends, who so.

I am updating an application that I developed short while ago (improving component, programming and version of MySQL). I migrated of MySQL 3.23.56 to 5.0.19 because I saw that the benefits are superior and mainly by the possibility of handling stored procedures.

I developed my stored procedures in MySQL-Front 3.2 and there I execute them and the truth I do not have any problem, the problem occurred when I wanted to execute those procedures stored in my application appeared to me the following error:
PROCEDURE xxx.yyy can't return to result set in the given context.

I use components Zeos 6.5.1 alpha CVS as of 13/10/2005 in Delphi 6, already I looked for solution this problem but the truth that I do not give him. somebody can help me?


2006/07/13 13:24 GMT-6:
Making an exhausted search I found solutions for those who use the function mysql_real_connect and this is to add option CLIENT_MULTI_STATEMENTS as parameter to the function but I have not found like doing using it my Zeos components.

Edited 1 time(s). Last edit at 07/13/2006 07:24AM by carlos malpica.

Options: ReplyQuote

Written By
PROCEDURE xxx.yyy can't return a result set in the given context.
July 12, 2006 03:43PM

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.