Page 1 of 1

Sproc OUT parameter

Posted: Wed 10 Aug 2005 10:32
by me
Hi,

I've downloaded the trial version to evaluate the product and I am encoutering the following error when I issue the ExecuteReader command. What does this exactly means? The sproc works perfectly from the MySQL command shell.

Error:
OUT or INOUT argument 4 for routine mydb.mysproc is not a variable

The sproc definition is as follows:
CREATE PROCEDURE `mysproc`(param1 VARCHAR(7000), param2 INTEGER(4), param3 INTEGER(4), OUT param4 INTEGER(4))...


Thanks

Posted: Thu 11 Aug 2005 12:50
by Oleg
MySQL network protocol does not support transfer of OUT parameters to client. You can use these parameters only on the server, for example, from another stored procedure.