Hi!
i try to make some procedure and i got Error 1414,
Code that i executed is below:
****************************************************
mysql> drop procedure sp_inout;
Query OK, 0 rows affected (0.13 sec)
mysql> create procedure sp_inout(INOUT P INT) SET @x=P*2;
Query OK, 0 rows affected (0.00 sec)
mysql> call sp_inout(2);
ERROR 1414 (42000): OUT or INOUT argument 1 for routine test.sp_inout is not a variable
***************************************************
What that error means?
and why is he showing when i call procedure.
thanks
i try to make some procedure and i got Error 1414,
Code that i executed is below:
****************************************************
mysql> drop procedure sp_inout;
Query OK, 0 rows affected (0.13 sec)
mysql> create procedure sp_inout(INOUT P INT) SET @x=P*2;
Query OK, 0 rows affected (0.00 sec)
mysql> call sp_inout(2);
ERROR 1414 (42000): OUT or INOUT argument 1 for routine test.sp_inout is not a variable
***************************************************
What that error means?
and why is he showing when i call procedure.
thanks