ORAFCE -> UTL_FILE -> pul_line

From: bj77 <jovino_blanco(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ORAFCE -> UTL_FILE -> pul_line
Date: 2012-01-13 12:00:46
Message-ID: 1326456046428-5142399.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2012-01-13 12:11:43 Appending a newline to a column value - in a psql cronjob
Previous Message Raymond O'Donnell 2012-01-13 10:52:04 Re: Postgresql allow connections without password