Sproc OUT parameter

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
me

Sproc OUT parameter

Post by me » Wed 10 Aug 2005 10:32

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

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Post by Oleg » Thu 11 Aug 2005 12:50

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.

Post Reply