Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> statement trigger fired inappropriately

statement trigger fired inappropriately

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: Fri, 7 Feb 2003 14:42:22 -0800
Message-ID: <MPG.18add62448cb2fa98968a@news.telepacific.net>


Hi,

Is this to be expected?

Table A is the master with a before insert, update trigger Table B is a detail table of A, with a foreign key constraint referencing Table A cascade delete.
Table C is a detail of Table B, with a foreign key constraint referencing Table B cascade delete.

Table A's update trigger deletes Table B records, but for this row in A there are no rows in B and yet, Table C's after insert, update, delete statement trigger is fired.

Why is Table C's trigger fired?

Thanks

-- 
Jim Poe
Fulcrum InteTech, Inc.
<jpoe_at_fulcrumit.com>

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.
Received on Fri Feb 07 2003 - 16:42:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US