Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: foocounter.CURRVAL

Re: foocounter.CURRVAL

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sat, 24 Mar 2001 00:18:18 +0100
Message-ID: <3ABBD9BA.55895FB5@0800-einwahl.de>

Hi Einar,

no, it will not give concurrency problems because the info about currval is stored sessionwise and nextvals are created in something similar to autonomous transactions. They are completely separated against each other.

Martin

Einar Magnus Råberg wrote:
>
> Frank wrote:
> >
> > Hi!
> >
> > foocounter.currval will contain the last generated sequence no after you
> > have inserted.
>
> But using just foocounter.CURRVAL after the first INSERT might lead to
> concurrency problems, e.g. if someone else incremented the counter
> exactly in-between my two INSERTs.
>
> Right?
>
> -Einar
Received on Fri Mar 23 2001 - 17:18:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US