Re: Database Trigger causing Mutating Table

There is a workaround for this. It basically inlvolves creating a table level before insert trigger, a row level insert trigger, and then a table level after insert trigger, and a package to store the changes. See Thomas Kyte's page for an example that will help you: http://osi.oracle.com/~tkyte/Mutate/index.html.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Jun 29 2000 - 00:00:00 CDT