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

Home -> Community -> Usenet -> c.d.o.server -> Re: Open a File from Oracle but only if it is close

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

Original text of this message

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