Page 1 of 1

Trouble while debuging stored procedure (2.0.49)

Posted: Tue 10 Jul 2007 12:11
by soaron
I try to save and debug procedure in
http://dev.mysql.com/doc/refman/5.0/en/sqlps.html
like that:

PROCEDURE test.test()
BEGIN
PREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
SET @a = 3;
SET @b = 4;
EXECUTE stmt1 USING @a, @b;
END

and catch this message:
Image

But in mysql console it works properly.

Posted: Tue 10 Jul 2007 13:14
by soaron
Using Concat function instead Execute...Using can solve this problem.

Posted: Mon 06 Aug 2007 09:27
by Duke
Try to re-deploy your debug engine.