Triggers

From: <flavoue_at_my-deja.com>
Date: Fri, 01 Oct 1999 14:32:19 GMT
Message-ID: <7t2glj$5s$1@nnrp1.deja.com>

Hi,
Here is my problem :
I have one table that I would like to update automatically. I used triggers to do that but it doesn't work.

Table :
ID_objet Attribute Value

A		Z1		12
A  		Z2		10
A 		Z3		120 	(12*10)

B		Z1		5
B 		Z2		3
B		Z3		15	(5*3)

I would like to calculate automatically the values 120 and 15 each time I insert an object
X with the attributes Z1 and Z2.
The help documentation of oracle says that I have to create 2 triggers, one (type : for each row) that insert in a temporary temble the value of the product and
one that update (type : for statement) the table. The second doesn't work.
Does any body know why?

Thank you a lot for your help.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 01 1999 - 09:32:19 CDT