Thread: ORAFCE -> UTL_FILE -> pul_line
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.
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