Re: how to know the latest sequence number?

From: Bill Han <billhan_at_seatech.bc.ca>
Date: Thu, 17 Jan 2002 17:27:59 GMT
Message-ID: <zQD18.36496$e4.8742139@news0.telusplanet.net>

Thanks Jeremy, I'm clear now.

Regards,
Bill

"Jeremy Ovenden" <jovenden_NOSPAM_at_hazelweb.co.uk> wrote in message news:1011264221.730153_at_adsl.fast.net.uk...
>
> "Bill Han" <billxhan_at_hotmail.com> wrote in message
> news:otx18.7994$0c.329172_at_news3.calgary.shaw.ca...
> > Hi Fred,
> >
> > Is this way safe if many users are running that procedure at the same
> time?
> > I mean just between INSERT and get CURRVAL events, what happens if there
> is
> > another user runs this procedure to increase the sequence value?
> >
> > Thanks for your help,
> > Bill
>
> This is perfectly safe, the currval is private to the session. Another
user
> would be connected to another session.
>
> The currval value is not accessible unless you have first selected the
> nextval.
>
> cheers
> jeremy
>
>
Received on Thu Jan 17 2002 - 11:27:59 CST