Trigger Problem.

From: Joao Barreto Fernandes <barreto_at_master.di.fc.ul.pt>
Date: 13 Dec 1994 21:25:22 +0100
Message-ID: <3ckvvi$ait_at_master.di.fc.ul.pt>


	Well. It is the 2nd time I post on this subject.
	It seems that the solutions people indicate me didn't work that well.

	I have this problem.

	I have a table where I let other people insert and update ( this is 
done under a course in database systems - it is only meaningful if thinking it as pedagogical) rows. Nevertheless I want to use the same table as a place where i account their moves. i.e. for each insert, update or delete people do I insert "another" row using certain fields to indicate theis action. If this makes sense doesn't matter. What matters is that Oracle doesn't let me insert another row than the one that triggered the trigger. It says that the table is mutating.
	Please help me.
				Joao Fernandes.  

-- 

# Joao Carlos de Oliveira Barreto Fernandes #
# e-mail : barreto_at_master.di.fc.ul.pt #
# <a href=http://www.di.fc.ul.pt/~barreto> </a> #
Received on Tue Dec 13 1994 - 21:25:22 CET

Original text of this message