Re: Open a File from Oracle but only if it is close

From: Chuck <skilover_nospam_at_softhome.net>
Date: 2 Dec 2004 21:14:49 GMT
Message-ID: <Xns95B3A545EB0DEskiloversofthomenet@130.133.1.4>

shirley_sanjuan_at_tutopia.com (Shirley) wrote in news:6aa4dd9a.0412021148.190f9ec5_at_posting.google.com:

> Hi,
>
> I am doing a program in Delphi that writes a file, and the file is
> read from Oracle using UTL_FILE. But I need Oracle reads the file only
> if the another program finish to write the file.
>
> ¿Somebody knows how I validate that?

Use some other mechanism to determine if the file is finished being written. For example have Oracle read a different file name than Delphi is writing. When delphi completes writing, have it rename the file to whatever oracle is looking for.

Chuck Received on Thu Dec 02 2004 - 15:14:49 CST