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 many chromosomes does a human normal diploid cell have? How many chromosomes does a human normal haploid cell have? How many are the sex chromosomes within each of them?

The human eye is an organ which reacts to light for various purposes. As a conscious sense organ, the mammalian eye permits vision. Cone and Rod cells in the retina allow conscious

Relation between taxonomy and ecology

Synthesis of citratefrom acetyl CoA and oxaloacetate: Citrate synthase catalyses this aldol condensation reaction with the release of CoA. There are certain inhibitors to  this re

Which of the following defines why the vast majority of segregation errors in human patients include the two sex chromosomes (XXY, XO, XYY) or chromosome 21 (triple 21)? A. The

What are blood enzymes? Enzymes are proteins that take out chemical reactions (as opposed to structural enzymes). Most of the detectable enzymes in the blood come from the seve

draw a well labled diagram of plasmotomy

The main objectives of study of ecology are: (i)              To study the distribution of biota local and geographical level. (ii)             To study the interrelationship

DISORDERS OF LIVER: In the foregoing  sections and sub-sections we have discussed about the common disorders of upper and lower gastrointestinal  tract. Now we shall discuss

Define Nutritional Requirements for Extreme Environments? Human beings have been able to survive and work under extreme environments of almost all regions of the earth, from po