He said that he has fixed the SQL so this problem won't happen again, but he
has to get around the file that is locked right now and was wondering how to
do that.
"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
news:3ed677d3$1_3_at_mk-nntp-1.news.uk.worldonline.com...
> "Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message
> news:lWpBa.1119$cp6.853031_at_news1.news.adelphia.net...
> > You might also be able to bounce Oracle to free the file.
> >
> >
> > "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> > news:3ED6252F.11000072_at_exxesolutions.com...
> > > David wrote:
> > >
> > > > Hi, I have been using DBMS_LOB to load files from a native file
system
> > > > into an Oracle 8.1.7.0.0 database. An excerpt of the code I have
used
> > > > is below (the line numbers are for reference only):
> > > >
> > > > 1. DBMS_LOB.FILEOPEN(l_BFILE);
> > > > 2. DBMS_LOB.LOADFROMFILE(l_CLOB,l_BFILE,500);
> > > > 3. DBMS_LOB.CLOSEFILE(l_BFILE);
> > > >
> > > > An exception on line 2. was thrown and the file was never closed,
that
> > > > is line 3 never executed. Now when I try to delete the file in the
> > > > underlying file system is says (Win2K) "Cannot delete xxxx.txt:
There
> > > > has been a sharing violation".
> > > >
> > > > I've fixed the problem in the code so that when exceptions are
raised,
> > > > the file will be closed from now on. But I am not sure now how to
get
> > > > Oracle to close the file it holding onto (other than taking down the
> > > > database/server which isn't an option).
> > > >
> > > > Hmmm. Ideas anyone?
> > > >
> > > > Thank you
> > > > David
> > >
> > > Reboot the machine. That is the universal solution for all Microsoft
> > > product problems: This one too.
> > >
> > > --
> > > Daniel Morgan
> > > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > > damorgan_at_x.washington.edu
> > > (replace 'x' with a 'u' to reply)
> > >
> > >
> >
> Maybe I'm missing something, but why not just trap and log the error on
line
> 2, so that the file gets closed anyway?
>
> Regards,
> Paul
>
>
Received on Thu May 29 2003 - 18:56:12 CDT
