Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE and locking
Paul Murphy wrote:
> If I use UTL_FILE.FOPEN to create a new file and write lines to the
> file with UTL_FILE.PUT_LINE and close the file when I'm done with
> UTL_FILE.FCLOSE_ALL, will the file be locked at the operating system
> level (Windows) until the UTL_FILE.FCLOSE_ALL is finished? If this is
> not the default behavior (file is locked on the OS level during
> writing) do you know of a way to make this happen? I'm having a
> problem with a program (BCI) trying to read the file before UTL_FILE
> is done creating it. I'd be happy with a shove in the right direction
> as to what to research, but if it's a simple answer that I missed,
> that would be appreciated as well. Thanks.
> Paul Murphy
Maybe you just need to "flush" the output from UTL_FILE frequently enough for the reading program to be happy. There is a parameter to UTL_FILE.PUT_LINE to force an immediate flush of the output buffer....
-Mark Bole Received on Thu Jan 22 2004 - 22:05:16 CST
![]() |
![]() |