Preserve log table entries using autonomous transactions in Oracle

Thursday Sep 21st 2006 by Staff

Developers can use autonomous transactions in Oracle to "step outside" the main transaction and do work that commits independently.


A database transaction is a unit of work that must either succeed completely or fail completely. In Oracle, a transaction starts with the first Data Management Language (DML) statement you execute, and ends when you issue a COMMIT statement to save the transaction or a ROLLBACK statement to throw it away.

The article continues at

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved