這段mysql預存程序是否有錯誤？

DELIMITER //create procedure largest_order(out largest_id int)BEGIN    declare this_id int;    declare this_amount float;    declare l_amount float default 0.0;    declare l_id int;    declare done int default 0;    declare c1 cursor for select orderid,amount from orders;    declare continue handler for SQLSTATE '02000' set done = 1;            open c1;    repeat         fetch c1 into this_id,this_amount;        if not done THEN            if this_amount > l_amount THEN                set l_amount=this_amount;                set l_id=this_id;            end IF;        end if;    until done end repeat;    close c1;    set largest_id = l_id;END//DELIMITER ;

代碼如上,在navicat報錯

回複內容：

DELIMITER //create procedure largest_order(out largest_id int)BEGIN    declare this_id int;    declare this_amount float;    declare l_amount float default 0.0;    declare l_id int;    declare done int default 0;    declare c1 cursor for select orderid,amount from orders;    declare continue handler for SQLSTATE '02000' set done = 1;            open c1;    repeat         fetch c1 into this_id,this_amount;        if not done THEN            if this_amount > l_amount THEN                set l_amount=this_amount;                set l_id=this_id;            end IF;        end if;    until done end repeat;    close c1;    set largest_id = l_id;END//DELIMITER ;

代碼如上,在navicat報錯

已解決，是代碼有遺漏，末尾缺少斜杠

