SQL & PL/SQL

Hi,

Here is the problem:

Table A has 4 triggers and one of them is updating a field in table B. On all but one installation table B does not get updated all the time. (We have this code on different versions of Oracle on Solaris, Windows and Linux)

From the triggers one is on delete and the other three are on "insert or update" including the one, which is supposed to update the B table. A simple update of the record usually takes care of the problem meaning that the trigger gets fired and the B table gets updated. At one point I had to run the update two times for the trigger to fire but I have not been able to reproduce this (update not firing the trigger)

There is nothing to disable the triggers. We have not been able to find anything special about the records, which when inserted in A and for which the trigger did not fire at the time.

Could it be that the existence of several triggers all of which are on "insert or update" causes the problem? What else can we look into? It is rather annoying because it happens only every so often and it is usually discovered days after the fact.

Thanks,
Jivko