Re: Constraint violation in spite of trigger with sequence

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 2 Feb 2010 09:49:28 -0800
Message-ID: <bf46381002020949k35d319f7sda3c8ddf6559ed0_at_mail.gmail.com>



On Tue, Feb 2, 2010 at 9:29 AM, Adam Musch <ahmusch_at_gmail.com> wrote:

> The only ways I know of to avoid a trigger is:
>
> 1. Disable it.
> 2. Use SQL*Loader in direct mode, which will write blocks directly,
> bypassing triggers.
>
>

There are other ways to disable a trigger, which is why I asked to see the code. Back to productive work now.

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 - 11:49:28 CST

Original text of this message