Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE and locking
pmurphy_at_scsinet.com (Paul Murphy) wrote in message news:<b6ab6d71.0401220701.18f27db2_at_posting.google.com>...
> 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
You'd be better served by using another mechanism to signal the file reading program.
What program is BCI? if you wrote it, you can change it.
Ed Received on Thu Jan 22 2004 - 13:17:11 CST
![]() |
![]() |