Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> "Instead Of Insert" Trigger
I am trying to dynamically do an insert or an update on a table w/ an "instead of insert" trigger on a base view over a table. My question is, how do i reference the values of the record that tried to get inserted. Can I use :new ? This is what i have so far, but it is wrong. Is what i'm trying to do even possible?
SELECT COUNT(blahID) INTO rCount FROM vRF_adv_data WHERE blahID = :new.blahID; IF rCount>0 THEN
UPDATE vRF_adv_data SET (Imp = :new.Imp,
icks = :new.icks) WHERE blahID = :new.blahID;
ELSE
INSERT INTO vRF_adv_data (blahID, Imp, icks)
values (:new.blahID, :new.icks, :new.icks);
END IF;
end trg_vRF_adv_data;
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Dec 06 2000 - 18:08:02 CST
![]() |
![]() |