Re: UTL_FILE, can I remove files ?

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Wed, 31 Mar 1999 02:37:08 +0100
Message-ID: <7drqn9$b7o$1@news.inet.tele.dk>

Jurij Modic wrote in message <36f16933.2475497_at_news.siol.net>...
>On Thu, 18 Mar 1999 11:40:12 +0100, Jan-Olav Eide <janolav_at_nr.no>
>wrote:
>
>>If for some reason one if the functions/procedures in
>>UTL_FILE should fail after a file is opened for writing
>>(e.g when a disk becomes full), there appears to be no way
>>of removing the incomplete file. How do people deal
>>with such a situation ?
>
>Obviously the file was not closed properly (UTL_FILE.FCLOSE) due to
>unhandeled (or improperly handeled) exception. In such situation the
>file will be closed after the session that opened it is terminated and
>you will be able to remove it.
>
>>--
>>jo
>
>HTH,
>Jurij Modic <jmodic_at_src.si>
>Certified Oracle7 DBA (OCP)
>================================================
>The above opinions are mine and do not represent
>any official standpoints of my employer

And the impatient can call UTL_FILE.FCLOSE_ALL to close all open file handles.

Finn Received on Tue Mar 30 1999 - 19:37:08 CST