If your Oracle DB version is 10.2 or higher, the UNLIMITED buffer_size syntax is available as noted in the doc link rp0428 posted above. The equivalent of UNLIMITED in a dbms_ouptut.enable call would be dbms_output.enable(NULL). I added the following (silly) example of a sibling child report to Employees under a parent Department report:
FOR indx IN 1 .. 25000
DBMS_OUTPUT.put_line (indx || ' and counting' || chr(13) || chr(10));
The suggestion worked. Thanks to all for the responses. I should have thought of it, but that is what makes these forums so great.... there are smart people willing to help.
FYI - the limit is really 1,000,000 bytes (not characters). So for some multi-byte character sets that could mean < 250K characters.
The maximum size is 1,000,000, and the minimum is 2,000 when the user specifies
And all PUT_LINE does is add to the buffer; it does NOT empty or take things out of the buffer. That is why is should NEVER be used in actual production code (packages, procedures, functions) since there IS no client to take things out.