Re: [TRIGGER DELETE] access values in where clause?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 21 Feb 2003 08:48:35 -0800
Message-ID: <3E565863.D1764DC7@exesolutions.com>

Dirk Schwarzmann wrote:

> Hi,
>
> (for Oracle 8.1.7)
>
> in delete trigger on a view, is there a way to access the values of
> an additional where clause?
> For instance, (how) can I access myVal in the trigger if the following
> statement is given:
>
> delete from myView where myVal = 15;
>
> Obviously, neither :new. or :old. is working.
>
> Thanks in advance,
> Dirk

Are you referring to an INSTEAD OF trigger.

Daniel Morgan Received on Fri Feb 21 2003 - 10:48:35 CST