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: Galen Boyer <galenboyer_at_hotpop.com>
Date: 2 Dec 2004 13:56:45 -0600
Message-ID: <upt1sxyrp.fsf@standardandpoors.com>


On 2 Dec 2004, shirley_sanjuan_at_tutopia.com wrote:
> 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?

Did you test whether utl_file.is_open solves this? I'm not sure, but it might. The documentation suggests this, but Oracle might only be able to tell if another Oracle process has it open.

-- 
Galen Boyer
Received on Thu Dec 02 2004 - 13:56:45 CST

Original text of this message

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