Re: replacement for DBMS_OUTPUT package?
From: Magnus Bengtsson <magnus.bengtsson_at_jeppesen.com>
Date: Wed, 11 Mar 2009 09:22:28 +0100
Message-ID: <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!!
>
Date: Wed, 11 Mar 2009 09:22:28 +0100
Message-ID: <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.
/Magnus Received on Wed Mar 11 2009 - 03:22:28 CDT