Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using insert statements in triggers and functions
As AK aludes there are some possible drawbacks to overuse: data
inconsistencies, self-locking, and strange errors, but Autonomous
transactions are useful in several circumstances besides just error
logging. Another valid use is auditing where attempts to change a
record (row) are logged and not just commited changes.
HTH -- Mark D Powell -- Received on Fri Jul 15 2005 - 09:14:34 CDT