Update mulitple columns

From: Chris Forlano <cforlano_at_nortelnetworks.com>
Date: Thu, 16 Sep 1999 00:32:39 +0100
Message-ID: <37E02C97.2FBD1CA1@nortelnetworks.com>

I'm using Oracle 8.0.5 on Solaris 2.6.

Is there any reason I cannot do the following?

create or replace trigger copy_run
after insert
on run for each row
begin

update testcycl

          set tc_user_01 = :new.rn_user_02,
          set tc_user_02 = :new.rn_user_03,
          set tc_user_03 = :new.rn_user_03
    where tc_test_id = :new.rn_test_id
        and tc_cycle = :new.rn_cycle;

end;

The fool thing is giving me compile errors.

Thanks,

Chris

--
Chris Forlano
TMS Project Manager
Nortel Networks, Maidenhead
590 4342 (01628 434 342)
cforlano_at_nortelnetworks.com Received on Wed Sep 15 1999 - 18:32:39 CDT