Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> UTL_FILE and locking
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
Received on Thu Jan 22 2004 - 09:01:55 CST
![]() |
![]() |