会出现如下错误:
ORA-20000: ORU-10027: buffer overflow, limit of 100000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 35
ORA-06512: at "SYS.DBMS_OUTPUT", line 198
ORA-06512: at "SYS.DBMS_OUTPUT", line 139
ORA-06512: at "WORK.SHOW_OLD_DISCNTS", line 52
ORA-20000: ORU-10027: buffer overflow, limit of 100000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 35
ORA-06512: at "SYS.DBMS_OUTPUT", line 198
ORA-06512: at "SYS.DBMS_OUTPUT", line 139
ORA-06512: at "WORK.SHOW_OLD_DISCNTS", line 52
1.不要输出到屏幕上,可以建一个测试表,插入到这个测试表的栏位里面,一样可以看结果。
2.自己写个function,把输出的值 进行换行处理。