"Keith" <keith.wilby_at_AwayWithYerCrap.com> wrote in message
news:Xns96216D64CAF11keithwilby_at_10.15.188.42...
> Hi. This is my first posting to an Oracle forum, please be patient with
> me,
> I'm a clueless newbie in Oracle.
>
> I want to create a trigger that updates a field when the contents of
> another field changes. I've tried two approaches but they both won't
> compile:
>
> create or replace trigger t_oms_arr_af
>
> before insert or update
> of ver_arr_status
> on oms_version_tbl
> begin
> if ver_arr_status = 'PASSED' then
> update oms_version_tbl
> set ver_arr_act_fin = sysdate;
> end if;
>
> end t_oms_arr_af;
> /
> show errors
>
> create or replace trigger t_oms_arr_af
>
> before insert or update
> of ver_arr_status
> on oms_version_tbl
> begin
> if :new.ver_arr_status = 'PASSED' then
> update oms_version_tbl
> set ver_arr_act_fin = sysdate;
> end if;
>
> end t_oms_arr_af;
> /
> show errors
>
> The second one gives the error "NEW or OLD references not allowed in table
> level triggers". I'm using Oracle 7.
>
> Thanks.
> Keith.
Received on Tue Mar 22 2005 - 05:13:35 CST
