Re: sequence mystery

I can't fully understand your question, but it is possible that you are losing sequence numbers as a result of the db crashing and stroing sequences in the sga cache. If you do this your sequence will start up at a later number than expected, the gap representing the cached sequenes that were lost.

> 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.
 

As to the rest of your question, I don't have the manual on hand. Received on Sat Sep 21 1996 - 00:00:00 CEST