Re: Question on Insert Trigger

Serge Rielau wrote:
> DA Morgan wrote:

>> 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.
>> Another person trying to put massive overhead where a simple
>> constraint would suffice: Why?

Until the OP posts a single business rule that can't be handled with a constraint ... that's my answer and I'm sticking with it. <g>

-- 
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.org