Re: Unable to write more than 1K with UTL_FILE

Hi.

 Sorry, but you hit UTL_FILE limit - 1022 bytes per record.  Think about either writing a number of lines instead of 1  or writing part of record to different files.  In both cases you will have to merge/append/concat your data  outside of Oracle.

 HTH. Michael.

In article <382042be.0_at_etsv0008>,
  raffaele.d'alba_at_snamprogetti.eni.it wrote:
> please try this with a DB oracle 7.3.xx:
>
> declare
> OUT_FILE UTL_FILE.FILE_TYPE;
> buffer varchar2(10) := 'a';
> counter integer := 0;
> begin
> OUT_FILE:=UTL_FILE.FOPEN('c:\temp\', 'test.txt', 'w');
> if utl_file.is_open(OUT_FILE) then
> while true loop
> UTL_FILE.PUT(OUT_FILE, buffer);
> UTL_FILE.FFLUSH(OUT_FILE);
> Counter := Counter+1;
> end loop;
> end if;
> utl_file.fclose(OUT_file);
> exception
> when others then dbms_output.put_line('record #:' || Counter);
> end;
> /
>
> as you can see the procedure exits at character 1023.
>
> I've to manage records with much more data, can anybody suggest me a
soluton?
>
> thank you in advance,
> Raffaele
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 03 1999 - 15:13:18 CST