SERVEROUTPUT (Oracle7 Syntax) |
SERVEROUT[PUT] ON | OFF} [SIZE n]
|
Controls whether SQL*Plus displays the output of stored procedures or PL/SQL blocks executed from the SQL*Plus prompt. Such output is most often generated by the DBMS_OUTPUT.PUT_LINE procedure.
Keywords
ON
Displays the output.
OFF
Suppresses the output of DBMS_OUTPUT.PUT_LINE. This option is the default.
SIZE
Sets the number of output bytes that can be buffered within the server. The default for n is 2000, and n must be between 2000 and 1,000,000.
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.