Re: sequence mystery

Vladimir Stavitsky <vlads_at_lvalue.com> wrote:

>Under certain circumstances i issue "CREATE SEQUENCE" statement
>from my C++ code to Oracle. Sequences are created fine, and later
>on i use them in the code with no problems.
 

>At some point, though, when, say, i have 5 sequences created this
>way, and the CurrVal is at some random point for each of them (say
>3, 2, 5, 1, 4), next access to any of them starts from 21 instead
>of the expected NextVal.
 

>Thanks a lot
>http://www.webvalue.com Vlad Stavitsky vlads_at_lvalue.com
>---------------------------------------------------------------------

Create your sequence with the 'NOCACHE' option.

jared still                  ---- ___o
jared_at_valleynet.com       ----  _`\ <,_
                       -----   (*)/o (*)
--------------------------------------