Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> [TRIGGER DELETE] access values in where clause?

[TRIGGER DELETE] access values in where clause?

From: Dirk Schwarzmann <Dirk.Schwarzmann_at_gmx.de>
Date: 20 Feb 2003 11:15:55 GMT
Message-ID: <b32ddb$1i1and$1@ID-93128.news.dfncis.de>


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 Received on Thu Feb 20 2003 - 05:15:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US