Re: Oracle8i and sequence tables

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 24 Oct 2000 17:46:15 -0000
Message-ID: <972411005.27242.0.nnrp-08.9e984b29@news.demon.co.uk>

No.

Currval and nextval are private to the session. There is an article on my website which may answer further questions.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

sooty70_at_my-deja.com wrote in message <8t498e$80c$1_at_nnrp1.deja.com>...


>Hi folks,

>

>Let me start by saying that I don't currently have access to an

>Oracle8i database so I can't test this on my own so I'm not being

>lazy. :-)

>

>If I get sequence.nextval from a given sequence and then start using

>currval for X amount of inserts/updates afterwards, if someone else

>performs a sequence.nextval in another session will my currval change?

>In short, is the sequence.currval session specific?

>

>Thanks, Martin

>

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Tue Oct 24 2000 - 12:46:15 CDT