What is the max line length when calling DBMS_OUTPUT.PUT_LINE?
February 27th, 2006 By Eddie Awad
First, what does DBMS_OUTPUT.PUT_LINE do? This procedure places a line in the buffer. This procedure is mainly used in debugging PL/SQL programs.
Syntax
DBMS_OUTPUT.PUT_LINE (item IN VARCHAR2);
Notes
- When you call PUT_LINE the item you specify is automatically followed by an end-of-line marker.
- Output that you create using PUT_LINE is buffered. The output cannot be retrieved until the PL/SQL program unit from which it was buffered returns to its caller.
In 10gR1 (10.1) and before
The maximum line length is 255 bytes.
In 10gR2 (10.2) and above
The maximum line length is 32767 bytes.
February 28th, 2006 at 2:24 pm
the versions should be:
In 10gr1 and before….
In 10gr2 and above….
the 32k line length was added in 10gr2…
February 28th, 2006 at 3:01 pm
Thanks for the clarification. I have updated the post.