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 -> UTL_FILE and locking

UTL_FILE and locking

From: Paul Murphy <pmurphy_at_scsinet.com>
Date: 22 Jan 2004 07:01:55 -0800
Message-ID: <b6ab6d71.0401220701.18f27db2@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 Received on Thu Jan 22 2004 - 09:01:55 CST

Original text of this message

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