Re: DBMS_LOB question - LOADFROMFILE problem

"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message news:w6xBa.1280$cp6.977125_at_news1.news.adelphia.net...
> 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".
-snip-

Oracle should release the lock on the file, if the session has ended. Figure out if his session is still lingering on?

Anurag Received on Thu May 29 2003 - 22:01:36 CDT