Hi!

Ok, here is what I know:

DBMS_OUTPUT has a buffer, which default size is 20000. Your buffer size is set as 2000, the minimum possible.


Here a note from the DBMS_OUTPUT header in the Oracle documentation:

"Messages sent using DBMS_OUTPUT are not actually sent until the sending subprogram or trigger completes. There is no mechanism to flush output during the execution of a procedure. "

That mean that your buffer don't get clear until the end of your PL-SQL block, so the problem is not the lenght of one of your line, but the sheer size of all the line of your view together.

But there is a way to solve the problem: change the size of the buffer. You could set a size of maximum 1,000,000 using the following:

DBMS_OUTPUT.ENABLE(your_new_size_in_integer);

It solve my problem not long ago: hope it help you as well!