Re: Help on Insert Triggers

Well, if there is nothing else to check, you may remove the entire "if" clause. As a consequence, the extra begin/end block would be also removed. For some reason it seems odd to me, but it will work.

create or replace trigger mytrigger
before drop on TableMain
for each row
begin
  insert into TableSecondary
  values (:old.ColId, :old.ColName, :old.ColDesc); exception
  when DUP_VAL_ON_INDEX then
    null;
end; Received on Sun Nov 06 2005 - 12:22:09 CST