Re: nextval problem

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Thu, 25 Nov 1999 13:05:05 +0100
Message-ID: <383D25F1.23F3B643@unilog.fr>

Hi !

We had some similar problems. Probably your sequence uses the CACHE n option, where n
is the increment you saw. Try to alter this sequence with NOCACHE.

Hope this helps.

Pierre CHARPENAY

AlLes wrote :

> Hi all,
> Could anybody help with my problem.
> I have the SQL like:
> "insert into table values(field.nextval, :name, :prof, :qualify, :price)"
> under ORACLE 7.3.
> ORACLE SQL+ makes everything alright. And if sql goes through Borland BDE
> nextval increases data not on 1 (increment by = 1) but on 20 or 15 or some
> like that :( Program in Delphi 3.0
> Sorry for my poor English.
> TIA
>
> Oleksiy Lesyk
> alesyk_at_iname.com
Received on Thu Nov 25 1999 - 06:05:05 CST