Oracle Database Administration: The Essential Refe

Name

SERVEROUTPUT

Synopsis

Oracle7:

SERVEROUT[PUT] {OFF | ON} [SIZE n]

Oracle8:.

SERVEROUT[PUT] {OFF | ON} [SIZE n] 
[FOR[MAT]  {WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED]}]

Controls whether to display the output (generated by the DBMS_OUTPUT.PUT_LINE procedure) of stored procedures or PL/SQL blocks in SQL*Plus.

OFF

Suppresses the output of DBMS_OUTPUT.PUT_LINE.

ON

Displays the output.

SIZE

Sets the number of bytes of the output that can be buffered within the server. The default for n is 2000, and n must be between 2000 and 1,000,000.

FOR[MAT] WRA[PPED[

Specifies that SQL*Plus will wrap output; line breaks will occur in the middle of words, if necessary.

FOR[MAT] WOR[D_WRAPPED]

Specifies that SQL*Plus will word-wrap output; line breaks will only occur at line boundaries.

FOR[MAT] TRU[NCATED]

Specifies that SQL*Plus will not wrap output, but will truncate it at the end of the line.