錯誤提示：

ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 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 BNZF.BNQUERYLINE 138
ORA-06512: at line 3

查閱了一下文檔，這里貼出一些與本錯誤有關的信息：

DBMS_OUTPUT.ENABLE (buffer_size IN INTEGER DEFAULT 20000)

PUT and PUT_LINE Procedure Exceptions:
ORA-20000, ORU-10027: Buffer overflow, limit of <buf_limit> bytes.
ORA-20000, ORU-10028: Line length overflow, limit of 32767 bytes for each line

Usage Notes
1)You can build a line of information piece by piece by making multiple calls to PUT, or place an entire line of information into the buffer by calling PUT_LINE.
2)When you call PUT_LINE the item you specify is automatically followed by an end-of-line marker. If you make calls to PUT to build a line, then you must add your own end-of-line marker by calling NEW_LINE. GET_LINE and GET_LINES do not return lines that have not been terminated with a newline character.
3)If your lines exceeds the line limit, you receive an error message.
4)Output that you create using PUT or PUT_LINE is buffered. The output cannot be retrieved until the PL/SQL program unit from which it was buffered returns to its caller.
For example, SQL*Plus does not display DBMS_OUTPUT messages until the PL/SQL program completes. There is no mechanism for flushing the DBMS_OUTPUT buffers within the PL/SQL program. For example:

SQL> SET SERVEROUTPUT ON
SQL> BEGIN
?? 2 DBMS_OUTPUT.PUT_LINE (‘hello’);
?? 3 DBMS_LOCK.SLEEP (10);
?? 4 END;

????? 很顯然當我們在輸出時,控制輸出結果的緩沖大小由DBMS_OUTPUT.ENABLE控制,buffer size默認為20000,每行最大的限制是32k,后面的一個例子是用來說明存儲過程是在緩存了所有數據后才將結果返回。所以當我們使用游標進行輸出 時，如果結果很多，將會超過這個值報ORA-20000, ORU-10027: Buffer overflow, limit of <buf_limit> bytes這個錯誤
解決方法：
在存儲過程begin后面加?:? DBMS_OUTPUT.ENABLE (buffer_size=>null)???? 表示沒有限制

總結

以上是生活随笔為你收集整理的PLSQL Developer 出现ORU-10027: buffer overflow, limit of 10000 bytes的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。