Re: After Update Trigger

From: Peter Kallweit <p_kallweit_at_arcor.de>
Date: Fri, 16 Jun 2006 08:48:13 +0200
Message-ID: <4492542c$0$11080$9b4e6d93@newsread4.arcor-online.net>

Hi DG,

your WHEN clause should be

	when(old.p_and_i_lead_id IS NULL )
                                  ^^

or otherwise your trigger will fire never, as you probably already found out ;-)

hth
Peter

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 Fri Jun 16 2006 - 01:48:13 CDT