OUTPUT Parameters in Stored Procedure
Posted: Wed 02 Nov 2005 20:46
Hi, I have this SP:
------------
CREATE PROCEDURE `z1`(param1 INTEGER(11), OUT param2 INTEGER(11))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
BEGIN
set param2=param1*2;
END;
-------------
when I try run ExecuteNonQuery() method I get error msg: "OUT or INOUT argument 2 for routine z1 is not a variable".
How I can get value from OUT parameters?
Thanks.
------------
CREATE PROCEDURE `z1`(param1 INTEGER(11), OUT param2 INTEGER(11))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
BEGIN
set param2=param1*2;
END;
-------------
when I try run ExecuteNonQuery() method I get error msg: "OUT or INOUT argument 2 for routine z1 is not a variable".
How I can get value from OUT parameters?
Thanks.