sequence mystery

Hi, everybody;
what happens here looks very stupid, but i will describe it anyway.

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.

It happened twice already, and it's pretty difficult to test, since the whole thing is generated step by step through my GUI.

Related question i have is wht's the field LAST_NUMBER in SEQ view; it is set to 1, 21, 41 and 61 for different sequences i have created. Whenever i create sequences, i do not supply any values, expecting to get defaults from Oracle.

Thanks a lot

-- 


---------------------------------------------------------------------

        ... occurrences like this will be few and far between ...

http://www.webvalue.com      Vlad Stavitsky          vlads_at_lvalue.com


---------------------------------------------------------------------