Oracle 10g DBMS_OUTPUT Line Length and Output
Limit Increases
Article by
Rampant Author
Chris Foot
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.
|
|
|
