declare
v_i number(20):=1;
v_shu varchar2(50):='bia';
begin
loop
v_shu:=v_shu||v_i;
dbms_output.put_line('c1的长度:' || length(v_shu));
insert into shuju values(v_i,
v_shu,
'2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss');
exit when v_i=1000000;
v_i:=v_i+1;
end loop;
end;
ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小
ORA-06512: 在 line 7
v_i number(20):=1;
v_shu varchar2(50):='bia';
begin
loop
v_shu:=v_shu||v_i;
dbms_output.put_line('c1的长度:' || length(v_shu));
insert into shuju values(v_i,
v_shu,
'2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','2008-8-8','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss','ssssssss');
exit when v_i=1000000;
v_i:=v_i+1;
end loop;
end;
ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小
ORA-06512: 在 line 7
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货