批量数据插入解决办法

批量数据插入
[code=SQL][/code]
declare 
idss int :=10402;
ids int :=11102;
begin 
loop 
exit when ids<12884;
insert into cp_org_owner(id,oo_org_id,oo_owner_id) values(idss,10000,ids);
ids:=ids+1;
idss:=idss+1;
end loop;
end;

------解决方案--------------------------------------------------------
insert into cp_org_owner(id,oo_org_id,oo_owner_id) values(idss,10000,ids);
commit;
------解决方案--------------------------------------------------------
exit when ids<12884; 改 exit when ids>12884;试试