Re: PL/SQL HELP NEEDED!!!!

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Wed, 16 Jun 1999 08:21:50 +0100
Message-ID: <odDiNRAOC1Z3Ew4u@ahardy.demon.co.uk>

In article <37673C14.B0B938D9_at_cornerpub.FUDD-SUX>, Barney Gumble <duff.drinker_at_cornerpub.FUDD-SUX> writes
>Thanx! It works now. :o)
>
>> or simply use custSeq.currval in the inserts here..
>
>I couldn't use CurrVal since there are several users updating data at the same
>time.
>CustSeq could change between NextVal and CurrVal.

CurrVal is for the current session.

If you use the NextVal, the CurrVal will contain the correct value even if someone else uses the sequence in between times.

Andy
--
Andy Hardy. PGP key available on request

Received on Wed Jun 16 1999 - 02:21:50 CDT