ORA-20000:ORU-10027:buffer overflow,limit or 10000 bytes

代码:输出内容超过10000 bytes

  
  begin
    for i in 1 .. 10000 loop
      dbms_output.put_line('i=' || i);
    end loop;
  end;

 

 

 

在代码增加一段:DBMS_OUTPUT.ENABLE (buffer_size=>null);

 
  begin
    DBMS_OUTPUT.ENABLE (buffer_size=>null);
    for i in 1 .. 10000 loop
      dbms_output.put_line('i=' || i);
    end loop;
  end;

 

posted @ 2024-04-08 14:34  Iven_lin  阅读(267)  评论(0编辑  收藏  举报