utl_file limits?

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 - 02:44:03 CDT