Unable to write more than 1K with UTL_FILE

From: <raffaele.d'alba_at_snamprogetti.eni.it>
Date: 3 Nov 99 14:12:14 GMT
Message-ID: <382042be.0@etsv0008>

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 Received on Wed Nov 03 1999 - 08:12:14 CST