"Robert Dimitrovski" <robert.dimitrovski_at_ht.hr> wrote in message
news:1054740676.466412_at_tuxri2.tkcrij.ht.hr...
> You have to raise a buffer size. The maximum is 1 000 000 bytes.
> Default value is 2000 bytes.
To clarify a bit: it's DBMS_OUTPUT buffer. To increase it, emit
DBMS_OUTPUT.ENABLE(<new_buffer_size>); before calling PUT_LINE.
There's still hard limit of 1,000,000 bytes for this buffer, so you can't
set it any bigger. If you expect larger output, consider using UTL_FILE
or DBMS_PIPE.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Wed Jun 04 2003 - 10:37:49 CDT
