Re: How do I avoid Mutating Table Error

Use a pre-insert/update trigger in your form or your database.

Venkata Terala (venkata_at_inetnow.net) wrote:
: 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

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.