Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence nextval problem
If you want to avoid this I think you should create your sequence with no cache
option.
Maija-Leena
Vincent Croquette wrote:
> When I select the nextval of a sequence, I sometimes get the previous value
> + the sequence cache size (def 20)
>
> Ex : Sequence.Nextval => 1
> Sequence.Nextval => 2
> Sequence.Nextval => 22 !!!!
>
> Thanks in advance to anyone could help
Received on Tue Mar 09 1999 - 08:50:39 CST
![]() |
![]() |