Re: NextVal quirk

From: Patrick Janidlo <janidlo_at_visionarysoftware.spamthis.com>
Date: Mon, 21 Sep 1998 09:28:09 -0500
Message-ID: <LtsN1.215$mC5.1233139@proxye1.nycap.rr.com>

Jurij Modic wrote in message <36040e70.7055832_at_news.siol.net>...
>
>Is it possible that you have the before/after insert trigger on that
>table which selects from the same sequence? That would be the only
>explanation I could think of.
>

Jurij,

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 - 09:28:09 CDT