Re: Sequence missing values

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