ORU-10028: line length overflow, limit o

纵横四海

**Starts**29-08-2005 17:42:36
FDPSTP 中的 ORACLE 错误 20000

原因：由于 ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 35
ORA-06512: at "SYS.DBMS_OUTPUT", line 133
ORA-06512: at "APPS.CUX_HR11_REPORT", line
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
DBMS_OUTPUT Line Length and Output Limit Increases
Oracle provides the DBMS_OUTPUT package to display debugging information from PL/SQL code. The package was not designed to display reports or format output to standard output. But there are times when developers need to pump out large amounts of diagnostic information to help them debug their programs.
But developers using 10G R1 and earlier versions were frequently constrained by DBMS_OUTPUT's 255 byte single line limit and total session limitation of 1 million bytes. As a result, when using SQL*PLUS to debug their PL/SQL code, developers often received the following error messages:
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
Single line limit of 255 bytes exceeded.

ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
Maximum amount of 1 million bytes per session exceeded.
10G R2 increases the single length line limit to 32,767 bytes and the overall session limit is removed altogether.
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
exec dbms_output.enable(100000);设置的是每个PLSQL会话的输出总量.