Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trigger puzzlement
Assuming you have only one row in t2 for each date ... your problem
might be just because of date and times ...
Try ...
BEGIN
-- test if record has already been inserted today
begin
select 'TRUE'
into v_exists from DUAL where EXISTS (select * from test.t2 where trunc(last_change) = Trunc(SYSDATE) and cmdy = :new.cmdy_sym);exception
set gv = :new.zone1 where last_change = trunc(SYSDATE) and cmdy = :new.cmdy_sym;
HTH
Raj
Received on Sun Feb 15 2004 - 10:27:55 CST