--如果执行了下面这段,会报buffer overflow limit of 2000 bytes:
declare
begin
for i in 0..1000 loop
dbms_output.put_line('不设定的话,输入太长会报错ORA-20000: ORU-10027:');
end loop;
end;
/
-- 不过可以自己来设定,如下:
declare
begin
dbms_output.enable(99999999999999);
for i in 0..1000 loop
dbms_output.put_line('设了dbms_output.enable(99999999999999)就不报错了');
end loop;
end;
/
declare
begin
for i in 0..1000 loop
dbms_output.put_line('不设定的话,输入太长会报错ORA-20000: ORU-10027:');
end loop;
end;
/
-- 不过可以自己来设定,如下:
declare
begin
dbms_output.enable(99999999999999);
for i in 0..1000 loop
dbms_output.put_line('设了dbms_output.enable(99999999999999)就不报错了');
end loop;
end;
/