UTL_FILE result before the end of the job

[zephan]

Dears,

I'm using utl_file.put_line to log the steps of a PL/SQL into a file on the server.

The first put_line statment is performed before any other action. And then the job logs the other steps, untill the end.

The feature works fine, but I'm not able to see the results (file size is 0) unless the job is finished or I kill the session.

Any idea about how to overcome that?

Regards,
Zephan

 

[zephan]

Well it seems Oracle doesn't write automatically to the file system unless autoflush is specified or flush procedure is used.

 

[SantaMufasa]

If you want to see data as the job progresses, you can, as part of the loop, you can close the file and then re-open the file with append mode...then you can see every "loop-chunk's-worth" of output as it goes.



Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[carp]

Or - have the program write to different files at different phases, closing the files as it progresses.

 

[zephan]

Thank you guys.By the way, it's ok by setting autoflush parameter to TRUE when opening the file.
Regards,
Zephan