Re: don't want trigger error to block insert

From: <stan_herrman_at_my-deja.com>
Date: Wed, 14 Jul 1999 21:30:43 GMT
Message-ID: <7mivi3$stg$1@nnrp1.deja.com>

Here's my hack at the fix:

CREATE TRIGGER table1_insert_trigger
  AFTER INSERT ON table1
  FOR EACH ROW
  WHEN(new.master_flag = '1')
  BEGIN
    insert into table2(id, filename, category, description)     select :new.id,

           :new.table1_filename,
           'image',
           'image: ' ||s.longname

    from table3 s
    where s.id = :new.id;
  EXCEPTION
   when DUP_VAL_ON_INDEX
   then
--

• This example does nothing when the error happens
• I suggest doing something, like logging the error
  --
  null ; END; /

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 14 1999 - 16:30:43 CDT