RE: Why won't my script terminate?

From: Jared Still (jkstill_at_cybcon.com)
Date: 04/03/04

  • Next message: Bart Lateur: "modifying RaisError/PrintError for one SQL statement" 
    To: Ronald J Kimball <rjk-dbi@focalex.com>
Date: Fri, 02 Apr 2004 19:52:42 -0800

    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:jkstill@cybcon.com]
    > > 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
    > >
    > >
    >

  • Next message: Bart Lateur: "modifying RaisError/PrintError for one SQL statement"

    Relevant Pages

    • Re: Problem accessing db through ASP.NET application
      ... The oracle driver does not release the connection with the reader. ... Bobby Ryzhy ... An unhandled exception occurred during the execution of the current web request. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Lock Table
      ... >> AnySQL wrote: ... >> It is impossible, in Oracle, to block a reader? ... and take a lock on anything read". ...
      (comp.databases.oracle.server)
    • Re: getting the oracle stored proc value in .net
      ... As it was created by Oracle, it seems to work better in most ... you are trying to read the same value from a Reader. ... I cannot see that value in my .net code ... I tested the oracle stored proc in sqlPlus and it is returning me value, ...
      (microsoft.public.dotnet.general)
    • Re: Oracle JDBC Issues
      ... The connections ... Oracle will *never* block a ... READ_COMMITTED means the reader will ... DBMS the hin that you want to exclusively lock that read data. ...
      (comp.lang.java.databases)
    • Re: Copying to CD
      ... A common problem with CD's that I have seen is that the session was not ... closed on the cd by the writing software and the reader cannot open an open ...
      (microsoft.public.windowsxp.help_and_support)