Re: Workaround for the 1000000-byte output buffer limit?

I assume that you are using the DBMS_OUTPUT package. Consider using the package UTL_FILE which (as far as I know) does not have such a limit and allows to flush the output file. Pitfall 1: The user oracle must have write permission in the directory where the output file is created.
Ptifall 2: in the init<db>.ora file add the line

           utl_file_dir = *

regards, Stephan

In article <7qsmlv$6c6$1_at_nnrp1.deja.com>,   Raiden Fighter <raiden_fighter_at_my-deja.com> wrote:
> Are there any tricks to bypass the 1000000-byte output buffer limit??
> (From the Oracle manual, it's impossible to flush the output buffer..
> why??)
>
> Thanks for your time.
> Lynx
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Sep 04 1999 - 22:23:17 CDT