Re: replacement for DBMS_OUTPUT package?
From: Anonymous Remailer <mix_at_awxcnx.de>
Date: Wed, 11 Mar 2009 21:39:52 +0100
Message-ID: <96e39c433919a2dbc494e2df9a1f0abc_at_awxcnx.de>
>
> 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.
Date: Wed, 11 Mar 2009 21:39:52 +0100
Message-ID: <96e39c433919a2dbc494e2df9a1f0abc_at_awxcnx.de>
"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