Re: Question on Insert Trigger

Serge Rielau wrote:

> Hypothetically: If the business rule depends on data in
> some table or a package variable (any sort of "external to the row"
> data), can it still be written as a constraint?
> Presumably VPD cannot "ignore" input data, so it isn't applicable here I
> guess.
>
> Cheers
> Serge

My initial answer is no but business rules, as we define them are not the kind of thing one would write to a package variable. If it is variable it is not a rule.

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