Check what type of trigger do you use ( before or after ).
Edo <edo_at_access.stp.si> wrote in message
news:38EDC4BC.458C7FF0_at_access.stp.si...
> 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 - 08:46:30 CDT
