Re: QUESTION ON SEQUENCE VALUES - 9iR2

In article <46bb4cb5$0$16331$88260bb3_at_free.teranews.com>, Brian Peasland says...
>
> For these types of situations, after I query NEXTVAL, I put the value
> into a variable so that I can recall it later. This way, I guarantee
> that I do not lose my sequence's value.
>
> The CURRVAL value should survive for the duration of your session. But
> some apps like many web apps do not always use the same session for the
> user. This is one of my primary drivers for storing the sequence value
> in a variable.
>
>

Late reply to your reply - the strange behaviour encountered was, predictably, application development error.....

Thanks.

-- 
jeremy