Re: AW: Constraint violation in spite of trigger with sequence
- From: Jared Still <jkstill@xxxxxxxxx>
- To: stiebing@xxxxxxxxxxxxxxx
- Date: Fri, 5 Feb 2010 08:33:09 -0800
On Fri, Feb 5, 2010 at 3:10 AM, A. Stiebing <stiebing@xxxxxxxxxxxxxxx>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
Other related posts:
