Re: TRIGGER BEFORE UPDATE

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1996/12/17
Message-ID: <32b6b761.1825865@dcsun4>#1/1

By simply coding:
CREATE OR REPLACE TRIGGER htbvz

       BEFORE UPDATE ON table
       FOR EACH ROW WHEN (new.bvz = 'Y')
       BEGIN
	     :new.status := 'C';
       END;

/

You can change the value of any of the :new variables in the BEFORE, FOR EACH ROW trigger. You don't need to do an update....

On Tue, 17 Dec 1996 14:40:20 +0100, Wolf Kammer <uzr10a_at_work6c.rhrz.uni-bonn.de> wrote:

>Hallo to who is looking at this,
>
>I must set the value of the columne "status" to 'C' ("Changed") as
>soon as an other column has been updated. My trigger
>
>CREATE OR REPLACE TRIGGER htbvz
>
> BEFORE UPDATE ON table
> FOR EACH ROW WHEN (new.bvz = 'Y')
> BEGIN
> UPDATE table SET status='C' WHERE :new.bvz='Y';
> END;
>/
>
>does not work since the table is mutating, that is being modified
>by the update. How can one do this simple thing?
>
>Thanks for any help, Wolf Kammer
>

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Tue Dec 17 1996 - 00:00:00 CST