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 -> Re: TRIGGER BEFORE UPDATE

Re: TRIGGER BEFORE UPDATE

From: Stephen A Tahmosh <tahmossx_at_itd.ssb.com>
Date: 1996/12/17
Message-ID: <596bkk$jfd@svna0001.clipper.ssb.com>#1/1

try:
:new.status := 'C';
instead of the update statement

Steve

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

Steve Tahmosh
State Street Bank Received on Tue Dec 17 1996 - 00:00:00 CST

Original text of this message

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