Re: Question on Insert Trigger

From: DA Morgan <>
Date: Fri, 07 Mar 2008 10:34:53 -0800
Message-ID: <>

Serge Rielau wrote:
> 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Mar 07 2008 - 12:34:53 CST

Original text of this message