It still won't block a reader. There's nothing you can do in Oracle that will block a reader.
Short of catching the odd bug or two that is. ;) Jared On Thu, 2004-04-01 at 07:49, Ronald J Kimball wrote: > 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 > > > > >
