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 -> forgot to close file handle

forgot to close file handle

From: Doug Cowles <dcowles_at_nospambigfoot.com>
Date: Wed, 01 Dec 1999 16:01:27 -0500
Message-ID: <38458CA7.83E2696E@nospambigfoot.com>


I've been testing a procedure using the utl_file package and some exceptions have been thrown where the hand is not closed. utl_file.fclose(handle) was not run. Now when I try to replace the file with a new one via ftp I get a "Cannot open or remove a file containing a running program" which I assume is because Oracle is still maintaining some hold on the file. This is Oracle 8.1.5 on AIX 4.2.3. How can I find these processes and shut them down? Any ideas?

Received on Wed Dec 01 1999 - 15:01:27 CST

Original text of this message

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