Using autonomous transactions, Biology

Assignment Help:

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


Related Discussions:- Using autonomous transactions

Explain photosynthetic prokaryotes and mitochondria, What evidence strength...

What evidence strengthens the hypothesis that chloroplasts could have been photosynthetic prokaryotes and mitochondria could have been aerobic prokaryotes? In fact that the chl

Permanent wilting percentage (pwp), Permanent Wilting Percentage (PWP) ...

Permanent Wilting Percentage (PWP) It is the percentage of moisture in the soil at which a plant wilts and does not recover unless water is added to the soil. PWP for clay is

Which is the type of nitrogen waste, Which is the type of nitrogen waste el...

Which is the type of nitrogen waste eliminated by beings of the class Reptilia? These beings excrete mainly uric acid. This substance is less toxic than ammonia and it can be k

Explain mid-diastolic and lafe diastolic pre systolic sound, Explain Mid-di...

Explain Mid-diastolic and Lafe Diastolic (Pre Systolic) Sounds ? Mid-diastolic sounds are S3 sounds and late diastolic (pre systolic) sounds are S3 sounds. Pre systolic Pacema

Absorption, Absorption The monosaccharides, amino acids and other prod...

Absorption The monosaccharides, amino acids and other products of digestion must be passed on to other tissues to be useful for the organism. The process by which the digested

Totipotency and pluripotency, Totipotency and Pluripotency In the sta...

Totipotency and Pluripotency In the starting we said that the fertilized egg cell (zygote) has the capacity or potentiality to give rise to all kinds of cell types, like a bl

Microorganisms on basis of oxygen requirement for growth, Q. Microorganisms...

Q. Microorganisms on basis of oxygen requirement for growth? On basis of oxygen requirement for growth: - Obligate Aerobes: Require oxygen for growth and multiplication e.g

Explain the factors affecting gi of foods, Explain the Factors Affecting GI...

Explain the Factors Affecting GI of Foods? A variety of factors affect GI of foods. The factors which affect the rate of glucose absorption from starchy foods and therefore the

Biota of oceans - ecosystem, Biota of Oceans - Ecosystem Life in the s...

Biota of Oceans - Ecosystem Life in the sea is not particularly abundant, though the diversity of organisms is very high. Almost every major group of animals and every major g

Tetanus, Tetanus This is an infectious, non-febrile disease of animals...

Tetanus This is an infectious, non-febrile disease of animals and man, and is characterised by spasmodic tetany and hyperaesthesia. The causative agent is Clostridium tetani,

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd