SET SERVEROUTPUT ON for PL/SQL : serveroutput « SQL PLUS Session Environment « Oracle PL/SQL Tutorial





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>










29.26.serveroutput
29.26.1.serveroutput controls whether your DBMS_OUTPUT.PUT_LINE calls go into the bit bucket
29.26.2.Setting up the server to communicate
29.26.3.set serveroutput on size 1000000;
29.26.4.SET SERVEROUTPUT ON for PL/SQL
29.26.5.set serveroutput on format truncated
29.26.6.set serveroutput on format word_wrapped