Re: trigger problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 7 Apr 2000 14:54:42 +0200
Message-ID: <955114704.5623.0.pluto.d4ee154e@news.demon.nl>

Do you _really_ think you will get an answer, when providing so little background ....
?

Regards,

Sybrand Bakker, Oracle DBA

"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 - 07:54:42 CDT