Re: How do I avoid Mutating Table Error

From: Ian Stevenson <stevenson_at_logica.com>
Date: 1997/05/19
Message-ID: <01bc6427$fa027b20$4611ea9e@P014330.LOGICA.CO.UK>#1/1

Venkat

I have written an article on this. It is an extract from "Oracle Design" by Stevenson and Ensor, published by O'Reilly and Associates. You can find it from my home page http://www.westmail.demon.co.uk

Ian

Venkata Terala <venkata_at_inetnow.net> wrote in article <337CFB5B.2DA8_at_inetnow.net>...
> Hi!
> I need to write some auditing information (like date a record was
> updated and the user name etc) to the table in which the change was
> made. I know this willcause a MUTATING TABLE error. Is there a work
> around for it ? MS SQL Server allows this kind of a change and I need
> to port that application to Oracle with similar functionality.
>
> Any postings on this will be greatly appreciated.
>
> Thank You
> Venkat
>
Received on Mon May 19 1997 - 00:00:00 CDT