Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> forgot to close file handle
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?
![]() |
![]() |