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

What is neurological complications congenital heart disease, What is Neurol...

What is Neurological Complications of Congenital Heart Disease ? Neurological complications contribute substantially to mortality and morbidity from congenital heart disease.

Cell Division, What is the difference between Mitosis and Meosis?

What is the difference between Mitosis and Meosis?

fat digestion requires two steps, Fat digestion requires two steps? What a...

Fat digestion requires two steps? What are the steps and what enzymes are used to accomplish each step?

Skeleton, biological significance of biology

biological significance of biology

Explain carboxypeptidase, Carboxypeptidase The  inactive  zymogen  proc...

Carboxypeptidase The  inactive  zymogen  procarboxypeptidase  is  activated  by  trypsin .The further action on the polypeptides is carried out by carboxypeptidase which  attac

Define interaction of vitamin c with other vitamins, Define Interaction of ...

Define Interaction of Vitamin C with other vitamins? a. Ascorbic acid and other vitamins: Ascorbic acid synthesis is diminished in thiamin and riboflavin deficiency. Vitamin

What is the meaning of obesity, What is the meaning of Obesity? Obesity...

What is the meaning of Obesity? Obesity is a condition resulting from accumulation of excess body fat. The fat deposition takes place because over a period of time, people cons

Classification of viruses, Classification of Viruses No evolutionary or...

Classification of Viruses No evolutionary or phylogenetic exist between viruses. A   nature system of classification cannot, therefore, be devised for viruses. Holmes (1948)

Factors controlling stomatal aperture, Factors Controlling Stomatal Apertur...

Factors Controlling Stomatal Aperture 'Khul Ja Sim Sim' the two rocks slide and the gates to a great treasure open. With these magic words "Ali Baba and Chalis Chor" could ope

Male gamete and the female gamete in a flowering plant, What is (a) the mal...

What is (a) the male gamete, and (b) the female gamete in a flowering plant?   (a) The male gamete in a flowering plant is the pollen grain (strictly, the gamete is the male

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