Re: PL/SQL HELP NEEDED!!!!

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 16 Jun 1999 12:18:45 GMT
Message-ID: <376895fc.2167346@newshost.us.oracle.com>

A copy of this was sent to Barney Gumble <duff.drinker_at_cornerpub.FUDD-SUX> (if that email address didn't require changing) On Wed, 16 Jun 1999 07:54:29 +0200, you wrote:

>Thanx! It works now. :o)
>
>> or simply use custSeq.currval in the inserts here..
>
>I couldn't use CurrVal since there are several users updating data at the same time.
>CustSeq could change between NextVal and CurrVal.
>
> Thanx again! - BG :o)

currval and nextval are SESSION specific. When you get a nextval -- currval will also return YOUR currval -- never anyone elses. currval would be utterly useless if it returned anything other then your last NEXTVAL...

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jun 16 1999 - 07:18:45 CDT