UTL_FILE - output not immediate
396612Dec 13 2007 — edited Dec 17 2007Hello -
I have a situation where I do not see reliable response from Oracle when using the file utility; UTL_FILE...
I'm using the UTL_FILE package to output results from a procedure to a Unix file, but the results are not written to the file by the time I close the file handle. The file output is not written until about 5 minutes after the procedure has finished. No exceptions are caught by "when others".
I call the UTL_FILE.fflush in the procedure and close the file handle. So the output is written using a "closed" file handle.
I'm not exactly sure what would cause that.
If there's some sort of contention going on that I don't know about, then shouldn't an exception be generated by Oracle and caught in my catch-all.
Version 9.2.0.7.0 on Unix
Any thoughts?
Thanks in Advance...