在plsql dev中使用dbms_output.put_line的时候报如下错误

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 5

详细日志如下：

[@more@]

SQL>
SQL> set serveroutput on;
SQL> begin
2 for c in (select * from dba_objects)
3 loop
4 dbms_output.put_line(c.object_name);
5 end loop;
6 end;
7 /

ICOL$
I_USER1

... ...

I_SNAP_REFTIME1
MLOG_REFCOL$

begin
for c in (select * from dba_objects)
loop
dbms_output.put_line(c.object_name);
end loop;
end;

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 5

SQL>

解决方法如下：

SQL> exec dbms_output.enable(9999999999);

PL/SQL procedure successfully completed

SQL>
SQL> begin
2 for c in (select * from dba_objects)
3 loop
4 dbms_output.put_line(c.object_name);
5 end loop;
6 end;
7 /

ICOL$
I_USER1
CON$
UNDO$

... ...

WRH$_SYS_TIME_MODEL
WRH$_SYS_TIME_MODEL_PK
WRH$_SYS_TIME_MODEL_PK
WRH$_SERVICE_WAIT_CLASS
WRH$_SERVICE_WAIT_CLASS_PK
WRH$_SERVICE_WAIT_CLASS_PK
BIG_TABLE
P_TEST

PL/SQL procedure successfully completed

SQL>

--end--

ITPub博客

解决 plsql dev中ORA-20000 ORU-10027 buffer overflow, limit of 2000 bytes 问题

最新文章