Re: how to know the latest sequence number?

From: Jeremy Ovenden <jovenden_NOSPAM_at_hazelweb.co.uk>
Date: Thu, 17 Jan 2002 10:45:05 -0000
Message-ID: <1011264221.730153@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 - 04:45:05 CST