Re: PL/SQL problems with UTL_FILE

In article <8ia8jm$h0p$1_at_serv1.iunet.it>,   "Piero" <p.dibello_at_reply.it> wrote:
> Hi,
> I'm having problems with pl/sql's utl_file package.
> I need to write a binary file, so I've used the put() function, but
 when I
> try to close the file I get an error...
> I know that the write buffer is limited to 1023 bytes (is it right?),
 so I
> tried to force writing to file with fflush(), but I got the same error
> during the file closing.... I can't image where is my mistake!
>
> Can you help me?
>
> Thanks
>
> Piero
>
>

utl_file cannot write a binary file.

utl_file, in versions before 8.0.5, cannot write stream of characters without putting out a newline at least every 1022 characters (eg: doesn't matter how often you flush, if you do not have a newline every 1022 bytes -- it'll fail)

in 8.0.5 and up, this limit is 32k.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.