Re: ORAFCE -> UTL_FILE -> pul_line

Hello

2012/1/13 bj77 <jovino_blanco@hotmail.com>:
> Hi,
>
> OS: SUSE LINUX
>
> I am writing a logfile (batch process) with the ORAFCE utilities of
> UTL_FILE.
> I recently observed that the logfile is not refreshed after every new entry
> written. It appears to me that the every 4096 bytes of data are written at
> the same time.
>

It doesn't flush after any write. Filebuffers are flushed when file is
closed or when function fflush is explicitly called.

Use utl_file.fflush(file utl_file.file_type)  after write, and then
your logfile will be fresh every time.

Regards

Pavel Stehule


> Can anyone explain me this please? And is it possible to change that in
> order to write every line directly into a file (being able to see the
> current file input with putty or WINSCP)?
>
> Sorry for my english, i hope you did understand my question.
>
> Thanks a lot in advance!
>
> Saludos
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/ORAFCE-UTL-FILE-pul-line-tp5142399p5142399.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general