trigger problem

Hi,
I'm useing Oracle 7.3

I have several tables, that contains information of some transitions. Some of data: buyer, pruduct and amount of bought product. I put trigger on each of them, so they would calculate amount of product left in storage and write it down in another table table.

When i tested it worked well. But lately i found some difference between data stored in table(data writen by triggers), and my own calculated data using querys. Retriving summary data is very simple so i didn't go wrong. Querys were tested by me and by some of my friends. Only Triggers can access table, except me and i never lock table or write in it.

My question is: Why and how triggers failed? Received on Fri Apr 07 2000 - 06:21:32 CDT