Re: Oracle8i and sequence tables

From: <sooty70_at_my-deja.com>
Date: Tue, 24 Oct 2000 20:38:01 GMT
Message-ID: <8t4rv8$pfh$1@nnrp1.deja.com>

Thanks!

In article <972411005.27242.0.nnrp-08.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 24 2000 - 15:38:01 CDT