Re: replacement for DBMS_OUTPUT package?
Date: Wed, 11 Mar 2009 21:39:52 +0100
"Magnus Bengtsson" <magnus.bengtsson_at_jeppesen.com> wrote in message news:gp7sc4$hiv$1_at_rifle.carmen.se...
> mh_at_pixar.com skrev:
>> especially one that doesn't have the 256 max chars/line >> and 1000000 max chars/buffer limitation. >> >> any hints and pointers appreciated!! >>
> If you are using older Oracle versions this won't help you, but:
> In Oracle 10gR2 and 11gR1 the limit for the line size is 32767 bytes,
> and the buffer size is unlimited.
What development tool are you using that will allow this:
DBMS_OUTPUT.PUT_LINE(RPAD('Z',32766,'Z')); Thank you. Received on Wed Mar 11 2009 - 15:39:52 CDT