要创建存储过程的话，begin前面少了个as

create procedure sdyprocedure()
is
declare
  i int default (1);
begin
    while i<= 10 loop
       insert into biz_real_param(param_id, eqpt_id) values(i,i);
     i:= i + 1;
    end loop;
commit;
end;