Oracle PL/SQL Tutorial/SQL PLUS Session Environment/serveroutput

serveroutput controls whether your DBMS_OUTPUT.PUT_LINE calls go into the bit bucket

   <source lang="sql">

SQL> SQL> set serveroutput on size 1000000 format wrapped SQL> SQL></source>

set serveroutput on format truncated

   <source lang="sql">

SQL> SQL> SQL> set serveroutput on format truncated SQL> exec dbms_output.put_line( " Hello World  !!!!!" );

    Hello     World     !!!!!

PL/SQL procedure successfully completed. SQL></source>

set serveroutput on format word_wrapped

   <source lang="sql">

SQL> SQL> SQL> set serveroutput on format word_wrapped SQL> exec dbms_output.put_line( " Hello World  !!!!!" ); Hello World  !!!!! PL/SQL procedure successfully completed.</source>

SET SERVEROUTPUT ON for PL/SQL

   <source lang="sql">

SQL> SQL> SET ECHO ON SQL> SET SERVEROUTPUT ON SQL> DECLARE

 2    age   NATURAL;
 3
 4  BEGIN
 5    age := 10;
 6    DBMS_OUTPUT.PUT_LINE("age:");
 7    DBMS_OUTPUT.PUT_LINE(age);
 8  END;
 9  /

age: 10 PL/SQL procedure successfully completed. SQL></source>

set serveroutput on size 1000000;

   <source lang="sql">

SQL> SQL> set serveroutput on size 1000000; SQL></source>

Setting up the server to communicate

By default, server output is turned off.

   <source lang="sql">

Set serveroutput on</source>