Re: Question on Insert Trigger
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Mar 2008 10:34:53 -0800
Message-ID: <1204914891.737927@bubbleator.drizzle.com>
> Can you squeeze in a view? I.e. rename the table, create select-* view
> over the renamed table using the original table name.
> Then create an INSTEAD OF TRIGGER on the view to intercept the rows you
> don't like. You can ignore them, save them away, or patch them up.
>
> Cheers
> Serge
Date: Fri, 07 Mar 2008 10:34:53 -0800
Message-ID: <1204914891.737927@bubbleator.drizzle.com>
Serge Rielau wrote:
> zigzagdna_at_yahoo.com wrote:
>> Thanks to all. not null in my code was just an example. My filtering >> logic is lot more complex and cannot implemented through a costraint. >> What I am asking is there a way to do filtering in the trigger if it >> cannot be done using EXCEPTIONS INTO statement.
> Can you squeeze in a view? I.e. rename the table, create select-* view
> over the renamed table using the original table name.
> Then create an INSTEAD OF TRIGGER on the view to intercept the rows you
> don't like. You can ignore them, save them away, or patch them up.
>
> Cheers
> Serge
Another person trying to put massive overhead where a simple constraint would suffice: Why?
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Mar 07 2008 - 12:34:53 CST