dbms_output大小缓冲区溢出 [英] dbms_output size buffer overflow

问题描述

我试图在存储过程中将dbms_output的大小设置为无限制.

I tried to set the dbms_output size to unlimited inside a stored procedure.

但是它给了我编译错误.因此，我尝试按照以下方式在SQL * Plus提示符下进行尝试.但是我仍然收到缓冲区溢出错误.我该如何克服?

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

推荐答案

在过程service_update中，很可能会调用

In the procedure service_update, by any chance is there a call to

dbms_output.enable(30000); 

这可能会覆盖您设置的第一个限制.

This may override the first limit you set.

这篇关于dbms_output大小缓冲区溢出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！