Re: database triggers!

From: Van Messner <vmessner_at_netaxis.com>
Date: Tue, 17 Nov 1998 20:06:03 -0500
Message-ID: <c7p42.661$G27.4640@news6.ispnews.com>

Take a look at the Oracle documentation that came on your Oracle CD. There's a good explanation of mutating triggers there.

Van

janakah_at_my-dejanews.com wrote in message <72qonn$mqt$1_at_nnrp1.dejanews.com>...
>I got two tables called file_volumes(master) and file_history( details) and
a
>foreign key is specified on file_history table. I wrote a simple database
>trigger based on file_volumes table to insert a new record into
file_history
>whenever file_volumes is updated. Then with the trigger enabled when I try
to
>update file_volumes I got an error ORA-04091 - name is mutating, trigger
may
>not read or modify it
>
>I drop the foreign key constraint on the file_history table and then the
>trigger works without any errors.
>
>Can someone explain to me the problem caused by the foreign key constraint
?
>
>Thanks in advance
>
>Janaka
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 17 1998 - 19:06:03 CST