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

Please answer the following question on Sequence Y: Protein databases 1. What sequence from which organism is this sequence most similar to? 2. Can you find any homo

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?

Q. What are some examples of interspecific competition? Instance of interspecific competition are the dispute among worms, vultures, flies and microorganisms for carrion and th


Determine amount of intracellular potassium ions in neuron A Neuron A is a healthy neuron with all the usual ion channels.  When at rest with a membrane voltage of R millivolts

Tr aumatic reticuloperitonitis (TRP) It is also known as traumatic gastritis, hardware disease or traumatic reticulitis. Et i o l o g y : Frequentl

Explain Clinical dietetics and Diet therapy Clinical dietetics  :  The application of  dietetics  in a hospital or health care institutional  setting. Diet therapy  :

Why Deficiency of Folate take place? If there is inadequate dietary folate, the activity of both the DNA and the methylation cycles, described above, will be reduced. A decrea

In radially symmetric animals there is no posterior, or anterior, right sides to the animal. Rather we refer to two sides of the animal by referring to the location of the mouth. I