Re: sequence mystery
From: Dave Marcus <dmarcus_at_notes.cc.bellcore.com>
Date: 1996/10/07
Message-ID: <53bknr$pt5_at_athos.cc.bellcore.com>#1/1
*>
*>Reposting article removed by rogue canceller.
*>
*>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
*>---------------------------------------------------------------------
I think what's happening is the currval returns the cache value of +20, try defining the sequence with no cache and see what happens. Received on Mon Oct 07 1996 - 00:00:00 CEST
Date: 1996/10/07
Message-ID: <53bknr$pt5_at_athos.cc.bellcore.com>#1/1
*In article <R.324430FD.2C01_at_lvalue.com>, vlads_at_lvalue.com says...
*>
*>Reposting article removed by rogue canceller.
*>
*>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
*>---------------------------------------------------------------------
I think what's happening is the currval returns the cache value of +20, try defining the sequence with no cache and see what happens. Received on Mon Oct 07 1996 - 00:00:00 CEST