Autonomous versus nested transactions, PL-SQL Programming

Autonomous versus Nested Transactions

Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below:

(i) It does not share the transactional resources (like locks) with the major transaction.

(ii)It does not depend on the major transaction. For illustration, if the major transaction rolls back, nested transactions roll back, while the autonomous transactions do not.

(iii)Its committed changes are visible to other transactions instantly. Whereas the nested transaction's committed changes are not visible to other transactions till the major transaction commits.

Posted Date: 10/5/2012 4:45:09 AM | Location : United States







Related Discussions:- Autonomous versus nested transactions, Assignment Help, Ask Question on Autonomous versus nested transactions, Get Answer, Expert's Help, Autonomous versus nested transactions Discussions

Write discussion on Autonomous versus nested transactions
Your posts are moderated
Related Questions
LONG and LONG RAW You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length o

Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

An analyst in the quality assurance office reviews the time lapse between receiving an order and shipping an order. Any orders that have not been shipped within a day of the order

IS NULL Operator The IS NULL operator returns the Boolean value TRUE whenever its operand is null or FALSE if it is not null. The comparisons including the nulls always yield NU

Find the account numbers of all customers whose balance is more than 10,000 $

Data Types in SQL - Character CHARACTER or, synonymously, CHAR, for character strings. When this type is to be the declared type of something (e.g., a column), the permissible

Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t

Built-In Functions The PL/SQL provides a lot of powerful functions to help you to manipulate the data. These built-in functions fall into the categories as shown below: error r

TYPES OF EVOLUTION - Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the resul