Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> statement trigger fired inappropriately
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