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

Define deuterostomes in animal kingdom, Define Deuterostomes in animal king...

Define Deuterostomes in animal kingdom? Coelomate animals are thought to have separated into two divergent lines of evolution in terms of the way embryos develop. In the embryo

What are the kinds of plant geotropisms, What are the kinds of plant geotro...

What are the kinds of plant geotropisms? Why do the root and the stem present opposite geotropisms? The kinds of geotropisms are the positive geotropism, that in which the plan

Consequences of population growth, T he effects of unlimited population gro...

T he effects of unlimited population growth are as follows: 1.         Increase in unemployment. 2.          Low per capita income. 3.         Low living standard

Avian influenza (ai), A v i a n influenza (AI) One of only two 'Lis...

A v i a n influenza (AI) One of only two 'List A' diseases of poultry targeted for emergency disease control measures by OIE, avian influenza is a highly contagious viral d

Blood transfusion , Blood transfusion  The blood of Raja cannot be t...

Blood transfusion  The blood of Raja cannot be transfused to Rama because the blood group of Raja is ‘B' and blood group of Rama is ‘A'. If Raja's blood with group ‘B' is

Explain process of stress testing in women, Q. Explain process of Stress Te...

Q. Explain process of Stress Testing in Women? Estrogen has been implicated as a cause of ST depression. For years it seemed that estrogen protect women from coronary artery di

Define preterm and low birth weight, Define Preterm and Low Birth Weight? ...

Define Preterm and Low Birth Weight? The foetal and neonatal health is mainly dependent on the birth weight and it has been well recognized that perinatal (from birth upto one

Cause the inhibition of apoptosis, We now understand that mutations that ca...

We now understand that mutations that cause the inhibition of apoptosis are found in tumors. Because proliferation itself is not induced by the inhibition of apoptosis, explain how

Define physiological effects on the git of prebiotics, Define Physiological...

Define Physiological effects on the GIT of prebiotics? Since prebiotics are fermented by the gut microflora, they may have physiological effects on the GIT such as: Cont

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