DBMS_OUTPUT.GET_LINES : DBMS_OUTPUT « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. DBMS_OUTPUT

SQL>
SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2    v_Data      DBMS_OUTPUT.CHARARR;
  3    v_NumLines  NUMBER;
  4  BEGIN
  5    -- Enable the buffer first.
  6    DBMS_OUTPUT.ENABLE(1000000);
  7
  8    DBMS_OUTPUT.PUT_LINE('Line One');
  9    DBMS_OUTPUT.PUT_LINE('Line Two');
 10    DBMS_OUTPUT.PUT_LINE('Line Three');
 11
 12    v_NumLines := 3;
 13
 14    DBMS_OUTPUT.GET_LINES(v_Data, v_NumLines);
 15
 16    FOR v_Counter IN 1..v_NumLines LOOP
 17      DBMS_OUTPUT.put_line(v_Data(v_Counter));
 18    END LOOP;
 19  END;
 20  /
Line One
Line Two
Line Three

PL/SQL procedure successfully completed.

SQL>