Re: After Update Trigger

Thanks everyone for your help this trigger worked after I removed the WHEN clause

create or replace trigger p_and_i_assigned_date_trigger Before update of p_and_i_lead_id
on request
fore each row
declare curr_date_time DATE;
begin
select sysdate intocurr_date_time from dual; :new.my_p_and_i_assigned_date := curr_date_time;  end;
/

    when(old.p_and_i_lead_id = NULL ) Received on Wed Jun 14 2006 - 15:36:14 CDT