Re: unnecessary linefeed

(Oracle 9.2.0.1 ....)

I guess it is a bug in 8.1.7 then.

I replaced utl_file entirely with a java package and everything works. Took only a few lines of code, despite my Java knowledge being nearly zero.

Hegyvari Krisztian

janik_at_pobox.sk (Jan) wrote in message news:<81511301.0409290224.3080f723_at_posting.google.com>...
> Tested on Oracle 9.2.0.1 ....
>
> --------------------
> CREATE DIRECTORY TEST_DIR AS 'c:\';
>
> DECLARE
> v VARCHAR(1000):=LPAD('X',1000,'X');
> v_file utl_file.file_type;
>
> BEGIN
> v_file:=utl_file.fopen('TEST_DIR','a.txt','w',32767);
>
> FOR i IN 1 .. 1000 LOOP
> UTL_FILE.PUT_LINE (v_file,v,TRUE);
> END LOOP;
> UTL_FILE.FCLOSE(v_file);
> END;
> ---------------------
>
> This test implies that you don`t need to open/close a file every xxx
> bytes,
> you probably hit the limit of the VARCHAR datatype. I so, then just
> rest the variable which represents "buffer" in UTL_FILE.PUT_LINE.
>
> BTW, if you want to see messeges in this newsgroup immediatly then go
> at:
> http://www.orafaq.net/usenet/now/thread.php?group=comp.databases.oracle.server
>
>
> Jan
>
>
> hegyvari_at_ardents.hu (Hegyvari Krisztian) wrote in message news:<9003d46f.0409282212.7c17b041_at_posting.google.com>...
> > Hello All,
> >
> > I use utl_file to produce a "relative" file for UNIX. This file has to
> > maintain the following characteristic:
> >
> > - absolutely no linefeed at all
> >
> > The problem I first came across was that I had to close the file and
> > re-open again with append after every 32768 bytes, otherwise Oracle
> > sent me an exception when I wanted to close the file. This is not a
> > problem. The problem is, that after every utl_file.fclose a linefeed
> > is appended to the file. I use utl_file.put to write the data between
> > fopen and fclose and I never send any linefeed out.
> >
> > Any ideas how to change this? Currently I am seriously thinking to
> > abandon utl_file and use Java to do the filewriting, the only pain
> > being that the package is already ready and I am not a Java expert.
> >
> > Running on 8.1.7.4 and 8.1.7.2
> >
> > Cheers,
> >
> > Hegyvari Krisztian
> >
> > pls cc any answers to hegyvari_at_ardents.hu, if there is an answer I
> > would be very happy to get it as soon as possible
Received on Sun Oct 03 2004 - 07:16:13 CDT