Using autonomous transactions, Biology

Using Autonomous Transactions 

The transaction is a sequence of SQL statements that does a logical unit of work. Frequently, one transaction starts the other. In several applications, a transaction should operate outside the scope of the transaction that executed it. This can happen, for e.g. If a transaction calls out to a data cartridge.

An autonomous transaction is an independent transaction started by the other transaction, the main transaction. The Autonomous transactions suspend the main transaction, to do the SQL operations, commit or roll back these operations, and then resume the major transaction.

1415_autonomous transaction flow.png

Figure: Transaction Control Flow

Posted Date: 10/5/2012 4:43:17 AM | Location : United States







Related Discussions:- Using autonomous transactions, Assignment Help, Ask Question on Using autonomous transactions, Get Answer, Expert's Help, Using autonomous transactions Discussions

Write discussion on Using autonomous transactions
Your posts are moderated
Related Questions
Q. How Cleaning agents works? Food particles and other debris provide good nutrients for the nlicroorganisms to grow. In fact, the food particles protect microorganisms d

What is arterial switch operation explain briefly? Arterial Switch Operation: Switching the Great arteries to restore the normal Ventriculoarterial connections. The coronary

Q. Why some trees lose their green color in the autumn? In autumn nights longer and days become shorter thus there is a reduction of the photosynthesis rate and some plants pre

What is monera? One of the 5 main kingdoms contains bacteria and blue/green algae. Does NOT have a cell membrane, or in other words, is made of prokaryotic cells. Actually,

Plant Water Role of Water in Plants You know that water is the main constituent of plant cells. It performs the following major functions Water as a Solvent Water is a v

Penicillin allergy Cefazolin is often used for prophylaxis in penicillin-allergic patients, but such patients rarely may have allergic reactions to cephalosporins. When allergy

explain the relationship between the terms.. Inducer,activation transcription factor,enhancer

Calculate the Concentration of Unknown Solution from Standard Curve? i) First take different volume of standard solution (say 0.2, 0.4, 0.6, 0.8, 1.0 ml) and then calculate the

Encystment – Protozoan Encystment is characteristic of the life cycle of many protozoan. The protozoan secretes a thickened envelope (cyst) around itself and becomes inactive

Q. Show the types of oesophagitis conditions? The two types of oesophagitis conditions: 1. Acute Oesophagitis - It is characterized by substantial pain on swallowing. It is