Re: Unable to write more than 1K with UTL_FILE

Hi,

..... or migrate to 8i where they pushed the limit to 32k

Cheers
Gerald

michael_bialik_at_my-deja.com wrote:

> 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 Thu Nov 04 1999 - 08:33:20 CST