Preserve log table entries using autonomous transactions in Oracle

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 http://builder.com.com/5100-6388_14-6116690.html?tag=sc