Trigger help

Hi everyone,
  I define 2 tables, A is the parent and B is child, and define a delete casading foreign key on table B. I want to implement updating in synchronism.

  I tried to update the foreign key field on A, of course it failed, so I define a before update trigger on that field to update the corresponding field of B. When updating on A it will cause error ORA-04091 and fail.

  How should I deal with that? Any help appreciated!

Ming

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet