Fwd: updating problems

• Forwarded message ---------- From: Simone Saravalli <s.saravalli_at_gmail.com> Date: 5-mag-2006 14.40 Subject: Re: updating problems To: Ghassan Salem <salem.ghassan_at_gmail.com>

2006/5/5, Ghassan Salem <salem.ghassan_at_gmail.com>:
> Simone,
> Can you post the code of your trigger?

Yes, this is an example of the table I want to update:

create table tab (

   a number not null,
   b date default current_timestamp
);

and then the trigger

create or replace trigger my_trig

   after update of a on tab for each row    begin

      update tab set b = current_timestamp where a=:new.a;    end;
/

Now I've written:

create or replace trigger my_trig

   after update of a on tab for each row    begin

      update tab set :new.b = current_timestamp where a = :new.a;    end;
/

but the trigger gets some compilation errors. Is it correct?

Thanks, Simone Saravalli

--
http://www.freelists.org/webpage/oracle-l