Re: Constraint violation in spite of trigger with sequence

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 2 Feb 2010 08:12:30 -0800
Message-ID: <bf46381002020812m5664b42drc53b985ce23229a8_at_mail.gmail.com>

On Tue, Feb 2, 2010 at 2:09 AM, A. Stiebing <stiebing_at_softcontract.de>wrote:

>
>
> In spite of we got an trigger with a sequence to update an unique id key on
> insert, we get constraint violations from time to time.
> Where could the cause be for that?
>
>

1) By what methods does data get into the table?

    Custom app? SQL Loader? Custom Utilities? Import?

2) Please post entire code for the trigger.

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 Tue Feb 02 2010 - 10:12:30 CST