我在oracle8.1.7上创建了一个存储过程,用来从一个DB中几个表选取一些数据插入到另一个DB中的相应表里,当完成后会用DBMS_OUTPUT.PUT_LINE来输出结果,但出现如下错误:
BEGIN
*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 91
ORA-06512: at "SYS.DBMS_OUTPUT", line 58
ORA-06512: at "SCE.PARA_ARCHIVING", line 134
ORA-06512: at line 2
我的程序代码片断如下:
DBMS_OUTPUT.PUT_LINE(total_pc || ' ROWS OF PARAMETRIC has been archived');
DBMS_OUTPUT.PUT_LINE(total_pm || ' ROWS OF PARA_MEASURE has been archived');
DBMS_OUTPUT.PUT_LINE(total_pmv || ' ROWS OF PARA_MEASURE_VALUE has been archived');
请教这是什么问题?有解决办法吗?