Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE and locking

Re: UTL_FILE and locking

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 22 Jan 2004 11:17:11 -0800
Message-ID: <4b5394b2.0401221117.4f7573ac@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US