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
Determine Energy demand for Vigorous or vigorously active lifestyles? These people engage regularly in strenuous work or in strenuous leisure activities for several hours. Exam

If three different traits are controlled by the unlinked genes A, B, and C, and each has multiple alleles so that A has 4 alleles, B has 6 alleles and C has 2 alleles, how many dif

Exchange of oxygen, nutrients, carbon dioxide and waste products from mother to fetus takes place through diffusion across the: a) Chorionic villi (pron: core-e-on-ick villi)

Highly active antiretroviral therapy (HAART) - The treatment of HIV infection requires combination therapy known as highly active antiretroviral therapy (HAART) along with inte

What is transgenic food? Transgenic beings are animals, microorganisms and plants that have recombinant DNA, i.e., genes from other plants, microorganisms or animals artificial

The Alanine  cycle Follow the alanine link in the alanine cycle. The process goes as under: 1)  Pyruvate formed from glycolysis in  the muscle  is converted to  alanine by t

Enumerate the Sizes and shapes of eukaryotic and prokaryotic cells It is thus possible, due to these similarities, to generalise about the structures and functions of cells. In

Secondary and Tertiary Consumers - Biotic Components Besides there are animals which depend on herbivores for food and are called secondary consumers. Since secondary consumer

Which terrestrial vertebrate group is extremely rare in deserts? The Amphibians are terrestrial vertebrates very rare in desert environments (although there are a few species a

Signal Transduction The body consists of a huge variety of cell types which must work together to sustain the life of an organism. They must respond to their environment and co