Re: Trigger to Prevent Update of Certain Columns
From: <zsirotic_at_my-deja.com>
Date: Mon, 07 Feb 2000 16:39:06 GMT
Message-ID: <87msf9$p7n$1_at_nnrp1.deja.com>
Date: Mon, 07 Feb 2000 16:39:06 GMT
Message-ID: <87msf9$p7n$1_at_nnrp1.deja.com>
This trigger is a statement trigger and can't use :NEW and :OLD values. For row trigger, you must write FOR EACH ROW option.
For example:
create or replace trigger
trg_&officename._divdata
before update on &officename._divdata
FOR EACH ROW
BEGIN …
With regards.
Zlatko Sirotic
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Feb 07 2000 - 17:39:06 CET