Re: Sequence.Nextval Question

From: Sherwin Anthony Sequeira <sherwin_at_sequeira.powernet.co.uk>
Date: 1997/11/08
Message-ID: <fnq246.tgd.ln@sequeira.powernet.co.uk>#1/1

In article <63v2of$4ro1_at_news.hk.linkage.net>,

"Robert Edgar" <robedgar_at_hkstar.com> writes:
> My understanding is that CURRVAL is on a per session basis ie if you call
> NextVal then that value will remain as you CURRVAL for this session until
> you again access NextVal ie it doesnt not change based on other users ....
> however when you call NextVal again it will not be one greater than CURRVAL
> exactly because other users have accessed the sequence.....

Nice to see a correct answer.

Regards

Tony Received on Sat Nov 08 1997 - 00:00:00 CST