Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence missing values

Re: Sequence missing values

From: Marc Legault <marclegault_at_tmi.ca>
Date: Wed, 14 Oct 1998 14:13:50 GMT
Message-ID: <yk2V1.4046$VW6.31111985@news.magma.ca>


Try changing the cache_size value for the sequence from whatever it is to 0 ( ZERO ). In the past, we had problems when it was non-zero.

Good luck.

fumi wrote in message <6vp7ru$f80$2_at_news.seed.net.tw>...
>
>Phil Britton ¼¶¼g©ó¤å³¹ <361cc5ca.21219522_at_pub.news.uk.psi.net>...
>>We're using a single sequence within a schema that is called in
>>various procedures that are run to set up a database. THe sequence is
>>owned by the schema and only one session is running on this schema.
>>After the procedures have been run it appears that the sequence has
>>been missing certain values. e.g a value that we had expected to be
>>1001 is actually 1009. The jump seems to be random. Does anyone have
>>*any* idea what could be causing this. Apart from the obvious ones
>>like somebody else getting the nextval, which is not happening.
>
>
>One possibility is the misuse of NEXTVAL and CURRVAL.
>Query the nextval once, and then query the currval during your
>procedures, you will get the same number.
>
>
>Hope this help!
>
>
>
Received on Wed Oct 14 1998 - 09:13:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US