Mysql循环游标作为其中一个参数插入到另一个表

-- 创建存储过程
DROP PROCEDURE IF exists init_budget_proc;
CREATE PROCEDURE init_budget_proc()
BEGIN
    DECLARE p_ou VARCHAR (64);
    -- 遍历数据结束标识
    DECLARE done varchar(2);
    -- 创建游标
    DECLARE ou_cur CURSOR FOR SELECT es.portalorg_ou as ou FROM  shop_info es where es.shoptype=0;
    -- 将结束标识绑定到游标
    declare continue handler for not found set done = true; 
    set done = false;
    -- 打开游标
    OPEN ou_cur;
    -- 开始循环
    read_loop:LOOP
        FETCH ou_cur into p_ou;
        IF done THEN
            leave read_loop;
        END IF;
         insert into eshop_info_data(code,name,portalorg_ou_mount) select em.`code`,em.`name`,p_ou from eshop_mall_data_info em ;
    end LOOP;
    -- 关闭游标
    close ou_cur;
end;

call init_budget_proc(); 运行成功