Re: AW: Constraint violation in spite of trigger with sequence

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 5 Feb 2010 08:33:09 -0800
Message-ID: <bf46381002050833j60730d92kef6f580d9204ed32_at_mail.gmail.com>

On Fri, Feb 5, 2010 at 3:10 AM, A. Stiebing <stiebing_at_softcontract.de>wrote:

>
> if(:new.id is null) then
> select seq_AUFT.nextval into :new.id from dual;
> end if;
>
>

There's the problem right there.

Some code passes in a value for ID and the sequence is bypassed.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 05 2010 - 10:33:09 CST