When running a test that produces output on DBMS_OUTPUT only the first 5000 lines are displayed in System Output.
Example:
CREATE OR REPLACE PROCEDURE test_dbms_output(
p_line_count IN INTEGER,
p_line_size IN INTEGER
) AS
l_line_count_length INTEGER := LENGTH(p_line_count);
BEGIN
FOR i IN 1 .. p_line_count LOOP
dbms_output.put_line(LPAD(i, l_line_count_length, '0') ||
RPAD('x', LEAST(p_line_size - l_line_count_length, 255), 'x'));
END LOOP;
END;
/
Create a test case that calls the above with parameter values 10000 and 80 will produce the following result:
********************************************************
Program: TEST_DBMS_OUTPUT; Finished at: 01.02.2008 09:53:53
********************************************************
00001xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
00002xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
[4997 lines removed]
05000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
where it should have displayed all 10000 lines. QCTO should have the capability so DBMS_OUTPUT. DBMS_OUTPUT should only be limited by the maximum buffer size in Oracle (virtually unlimited from 10.2).
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center