dbms_output 大小缓冲区溢出
我尝试在存储过程中将 dbms_output 大小设置为无限制。
但它给了我编译错误。所以我在 SQL*Plus 提示符下尝试了以下方法。但我仍然收到缓冲区溢出错误。我怎样才能克服这个问题？
set serveroutput on size unlimited;
exec service_update;
ORA-20000: ORU-10027: buffer overflow, limit of 30000 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 "ARBOR.SERVICE_UPDATE", line 27
ORA-06512: at line 1
I tried to set the dbms_output size to unlimited inside a stored procedure.
But it gave me compilation errors. So I tried in the SQL*Plus prompt the below way. But still I get the buffer overflow error. How can I overcome this?
set serveroutput on size unlimited;
exec service_update;
ORA-20000: ORU-10027: buffer overflow, limit of 30000 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 "ARBOR.SERVICE_UPDATE", line 27
ORA-06512: at line 1
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
在过程 service_update 中，有可能调用
This 可能会覆盖您设置的第一个限制。
In the procedure service_update, by any chance is there a call to
This may override the first limit you set.
在 Oracle 10gR2 中，您还可以使用无限缓冲区 (https://forums.oracle.com /forums/thread.jspa?threadID=361639):
In Oracle 10gR2 you may also use unlimited buffer (https://forums.oracle.com/forums/thread.jspa?threadID=361639):