Thanks, but the script in question included an UPDATE statement. That is what I believe was blocking.
Ronald > -----Original Message----- > From: Jared Still [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 10:41 AM > To: Ronald J Kimball > Cc: DBI List > Subject: RE: Why won't my script terminate? > > > Writers don't block readers in Oracle. Not issuing a commit > will not cause a SELECT in another session to hang. > > Jared > > On Thu, 2004-03-25 at 09:49, Ronald J Kimball wrote: > > 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 > >
