Re: utl_file limits?

I believe, this may be similar to the limits on dbms_output.put_line, which is 2000 bytes. I have not tried this but would like to know if it works.

Try, either

SQL*Plus, PL/SQL:

execute dbms_output.enable(1000000);

                 OR
SQL*Plus:

set serveroutput on size 1000000  

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

David Chasteen <davidc_at_opteamasoft.com> wrote in article <6qosqe$9lp$1_at_camel18.mindspring.com>...
> I get an "ORU-10027 buffer overflow, limit of 20,000 bytes" error when
> writing a long file (it gets to 156 kb) from a procedure. It still does
it
> after opening, writing, flushing, and closing the file on each statement
as
> it loops through creating the line. For example:
>
> -- declared earlier...
> table_dml := UTL_FILE.FOPEN ('c:\aopt\vss\dev\db\install\dml',
> table_nm||'.sql', 'A');
> -- Write load data command for table into loaddata.sql
> UTL_FILE.PUT_LINE(table_dml,col_line);
> UTL_FILE.FFLUSH(table_dml);
> UTL_FILE.FCLOSE(table_dml); -- close table DML file
>
> I looked high and low for the "buffer" parameter the message is refering
to
> in order to set it higher.
>
> Is there a "buffer" parameter for writing out to a file?
> Is it in the SGA?
> Is it limited to 20000k or can it be set higher?
> Any ideas on strategy to get around this limit?
>
> Thank you,
>
> David
>
>
>
Received on Tue Aug 11 1998 - 09:40:16 CDT