Trigger howto

[Quoted] I have a Table like

START_DATE          EXEC_DAYS       EXEC_DATE
15-OCT-00                -10                         5-OCT-00

Now I need a Trigger to update
the EXEC_DATE when the START_DATE changes.

I tried

  create or replace
  trigger my_trigger
  after update or insert
  on my_table
  for each row
  begin
    if updating then

       :new.EXEC_DATE := START_DATE + EXEC_DAYS;     end if;
 end;

But can't use START_DATE and EXEC_DAYS

tried my_table.START_DATE also not worked

do I have to make a select for the START_DATE and EXEC_DAYS but how to find the right row...

Found info's about updating other Tables but nothing about my problem.

Thanks for any help
Greg Received on Wed Sep 20 2000 - 00:00:00 CEST