But what I didn't tell you, Ronald, was that I *did* commit after my updates in the SQLPlus session ... I might have forgotten once, but my Perl script didn't produce any output unless I did the Commit; so that helped to remind me.
So I don't think that was the problem after all. -----Original Message----- From: Ronald J Kimball [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 12:50 PM To: 'Tim Bunce' Cc: [EMAIL PROTECTED] Subject: RE: Why won't my script terminate? By the way, Laurie mentioned to me off-list that she had an SQLPLUS session open so she could reset the value of the contribute_flag column. That could have led to the script blocking, as I supposed. I've done that myself quite a few times, forgetting to commit in SQLPLUS while testing a script. :) Ronald > -----Original Message----- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 25, 2004 7:21 AM > To: Laurie Vien > Cc: [EMAIL PROTECTED] > Subject: Re: Why won't my script terminate? > > On Wed, Mar 24, 2004 at 04:08:17PM -0500, Laurie Vien wrote: > > Thank you very much to everyone who replied. The combination of your > > answers put me on the right path; I got it! > > > > I moved the "$sth->finish();" up to right after the close of the While > loop, > > instead of leaving it at the end of the script. That solved it. > > > > Thanks, all, for your help. > > Laurie, can you help me now? I'd like to understand the cause of this. > > Please put the finish() back where it was, to reproduce the problem, > and then start stripping out all the code between the end of the > while loop and the finish. Piece by piece. If you remove something that > fixes it then put that back and keep removing other things until all > that's left is the minimal amount of code required to causes the problem. > > Then I'd appreciate it if you could add: DBI->trace(9,"dbitrace.txt"); > just after the file loop and send that file to me. > > Thank you! > > Tim. > > p.s. Please also include the output of perl -MDBI -e "DBI- > >installed_versions"
