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
Distinguish between epithelial and connective tissues with respect to their cell arrangement? PROVIDE a specific example( for both tissue types) of how the arrangement of cells hel

What is the cause of the immunodeficiency presented by AIDS patients? The cause of the immunodeficiency shown by AIDS patients is the destruction of CD4 T helper lymphocytes by

The  Cori cycle a)  Pyruvate formed from glucose is converted  to lactate by lactate dehydrogenase in the muscle cell. b)  Lactate is released into  the blood and taken up b

What are the main biological functions of the polysaccharides? Polysaccharides have an energy storage function and a structural function. Polysaccharides incorporated by living

Q. Calculate ideal weight for a diabetic patient? We now know that diabetes is the outcome of many genetic and environmental factors. The former is not in our control but the l

When the chromosomes  are depleted  of histones  they  are seem  to have  a central fibrous 'protein  scaffold'  or nuclear  matrix  to which the DNA is attached  in loops. Therefo

Economic Status Economic Status  :  It is one of the important practical considerations to be kept in mind while  formulating  a diet prescription. During  an acute illness, a

Q. Haemodynamic Study of constrictive pericarditis? Simultaneous right and left heart studies are useful. Due to exaggerated waves in atria, W-shaped atrial pressure tracing wi

Explain risk factor at the global perspective in heart diease? While the risk of Cardio-vascular diseases has been found to be variable in different ethnic groups with the high

OLIGOSACCHARIDES They are small-sized polymers of monosaccharides having 2 - 6 simple sugars, occasionally upto 9 - 10. Oligosaccharides are soluble in water, sweet to t