◆请教关于MySql创建Function的问题，急！◆

sking

以下这段脚本报错，请高手指教，谢谢！

create function fun_getCityByOid(oid int,split varchar(10)) returns varchar(400)
    begin
        declare done int default 0;
        declare result varchar(1000);
        declare retStr varchar(100);
        declare cur cursor for
            select d.cityName from t_order a
            inner join t_order_rec_detail b on a.oid = b.oid
            inner join t_reciever c on b.rid = c.rid
            inner join t_city d on c.cityid = d.cityid
            where a.oid = oid
            group by c.cityid;
        DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
        set result = '';
        open cur;
        repeat
        fetch cur into retStr;
            if not done then
            set result = concat(result, retStr, split);
            end if;
        UNTIL done end repeat;
        close cur;
        return substring(result,1,char_length(result)-1);
    end;


报如下错误信息：

错误代码: 1064
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 '' at line 3
(耗费 0 ms)

错误代码: 1064
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 result varchar(1000)' at line 1
(耗费 0 ms)

错误代码: 1064
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 retStr varchar(100)' at line 1
(耗费 0 ms)

错误代码: 1064
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 cur cursor for
            select d.cityName from t_order a
            inner join t_ord' at line 1
(耗费 0 ms)

错误代码: 1064
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 CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1' at line 1
(耗费 0 ms)

错误代码: 1193
Unknown system variable 'result'
(耗费 0 ms)

错误代码: 1064
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 'open cur' at line 1
(耗费 0 ms)

错误代码: 1064
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 'repeat
        fetch cur into retStr' at line 1
(耗费 0 ms)

错误代码: 1064
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 'if not done then
            set result = concat(result, retStr, split)' at line 1
(耗费 0 ms)

错误代码: 1064
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 'end if' at line 1
(耗费 16 ms)

错误代码: 1064
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 'UNTIL done end repeat' at line 1
(耗费 0 ms)

错误代码: 1064
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 'close cur' at line 1
(耗费 0 ms)

错误代码: 1064
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 'return substring(result,1,char_length(result)-1)' at line 1
(耗费 0 ms)

错误代码: 1064
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 'end' at line 1
(耗费 0 ms)