|
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>
|