mysql 带有游标的存储过程

DELIMITER $$

DROP PROCEDURE IF EXISTS `jf`.`insert2`$$

CREATE PROCEDURE `insert2`(in yhbh varchar(50),out bjbh varchar(50))
BEGIN
    declare tempbjbh varchar(50) default 0;
    declare done int default 0;
    declare cur1 CURSOR FOR select ffgl.c_bjbh from ffgl,dj_info where ffgl.c_yhbh='U01010101' and ffgl.n_fflx=dj_info.n_fflx order by ffgl.c_bjbh asc;
   
    declare CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1; 
    open cur1;
   Repeat
    fetch cur1 into tempbjbh;
    if not done then 
      set tempbjbh=concat(tempbjbh,"/");
      set bjbh=concat(bjbh,tempbjbh);
    end if;
until done end repeat;
   close cur1;
  select bjbh; 
    END$$

DELIMITER ;

 游标定义语句一定要放到其他变量的定义后边，否则会出错，如第8行和第9行换一下位置，就会报错。