Search Postgresql Archives

Re: ORAFCE -> UTL_FILE -> pul_line

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello

2012/1/13 bj77 <jovino_blanco@xxxxxxxxxxx>:
> 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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux