Re: Question on Insert Trigger

From: DA Morgan <>
Date: Sat, 08 Mar 2008 06:21:05 -0800
Message-ID: <>

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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Mar 08 2008 - 08:21:05 CST

Original text of this message