Re: UTL_FILE, can I remove files ?

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 18 Mar 1999 21:59:08 GMT
Message-ID: <36f16933.2475497@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 Received on Thu Mar 18 1999 - 15:59:08 CST