Just a remark :
You can directly affect sysdate to my_p_and_i_assigned_date :
:new.my_p_and_i_assigned_date := sysdate;
Ciao,
oLLiE
dwgabel_at_telus.net wrote:
> 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 Thu Jun 15 2006 - 06:49:40 CDT
