SQL Code: DROP PROCEDURE IF EXISTS `5000aaa`.proc_test; CREATE PROCEDURE `5000aaa`.`proc_test`() BEGIN DECLARE done INT DEFAULT 0; DECLARE cur_test CURSOR FOR SELECT user_cde FROM web_org_user LIMIT 0,1; DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1; END;
Error Info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE CALL questsoftware.DEBUGSET('done','L',done)' at line 1 CREATE PROCEDURE questdebug.1b52f6afbb5ef9e22cd76ca8a01efee86a8c7eaeimpl() BEGIN DECLARE done INT DEFAULT 0; DECLARE CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','5000aaa','proc_test',5);cur_test CURSOR FOR SELECT user_cde FROM `5000aaa`.web_org_user LIMIT 0,1; DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1; CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','5000aaa','proc_test',8);END;
Suggest: Toad for MySql 5.0.0.345, Statement "DECLARE cur_test CURSOR FOR xxx" is replaced by "DECLARE CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','5000aaa','proc_test',5);cur_test CURSOR ", are there any Settings must be setted for Toad ?
Sorry for All: i'm not good at English
|