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 -> Closing a file left open by utl_file

Closing a file left open by utl_file

From: glennh <glennh_at_kw.igs.net>
Date: Tue, 03 Nov 1998 23:50:24 -0500
Message-ID: <363FDD10.D7169738@kw.igs.net> 





utl_file is used from a stored procedure to read an OS file (NT, Oracle
8.0.4).  The stored procedure (which was bathed off) does not close the
file properly (fclose not called).  The file is now locked in NT and
cannot be moved, renamed, or deleted without rebooting the server.  Is
there a way to close this file from within Oracle or NT?



Thanks


Glenn


glennh_at_kw.igs.net

Received on Tue Nov 03 1998 - 22:50:24 CST












Original text of this message













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