存储过程调用存储过程

create procedure proc_main()
begin
     declare done INT default 0;
     declare d_user_id varchar(50);
     declare username_c varchar(50);
     declare userid CURSOR for select user_id from user;
     declare EXIT HANDLER FOR NOT FOUND SET done=1;
     open userid ;
     while done<>1 do
     fetch userid into d_user_id ;
           select username into username_c from user where user_id=d_user_id;
           call proc_user_insert(d_user_id);
           call proc_method(d_user_id,username_c);
     end while;
     close userid;
end;