Re: NextVal quirk

From: Patrick Janidlo <janidlo_at_visionarysoftware.spamthis.com>
Date: Mon, 21 Sep 1998 09:30:07 -0500
Message-ID: <BvsN1.216$mC5.1233885_at_proxye1.nycap.rr.com>


Joel Garry wrote in message ...

>RTFM. The SQL Reference notes that you must first initialize the sequence
>with NEXTVAL. Oracle increments it once for how ever many times you use
>the two vals in a statement, so either you are not incrementing by one or
>you have another statement in your transaction incrementing NEXTVAL.
>

Joel,

Thanks for the help. The problem occurred during the importing of an Access database via the oracle access assistant tool. The tool created the trigger on the table for an access "autonumber" field. Thus, the double incrementing of the number on an insert statement.

Thanks!

-pat Received on Mon Sep 21 1998 - 16:30:07 CEST

Original text of this message