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 the criterion used to classify hosts, What is the criterion used to...

What is the criterion used to classify hosts as intermediate hosts or as definitive hosts? The criterion used to classify hosts as intermediate hosts or as definitive hosts is

Describe metabolism, Q What is metabolism? Metabolism is the set of che...

Q What is metabolism? Metabolism is the set of chemical and physical processes upon which the life of the cells of a living being depends.

Describe the dinosaurs in multimedia tutorials, Describe the Dinosaurs in m...

Describe the Dinosaurs in multimedia Tutorials? Travel back to a time when dinosaurs ruled the earth. Learn about the different types of dinosaurs and practice building your ow

Coa to succinate in the citric acid cycle, Name the high-energy complex gen...

Name the high-energy complex generated during the conversion of succinyl CoA to succinate in the citric acid cycle GTP  or  ATP is  the high-energy  complex generated during th

Give example of ex-situ conservation, Which one of the following is an exa...

Which one of the following is an example of ex-situ conservation? 1. Wildlife sanctuary 2. Seed bank 3. Sacred groves 4. National park Seed bank

Explain briefly about vitamin B12, Vitamin B 12 (Cyanocobalamin) Vitam...

Vitamin B 12 (Cyanocobalamin) Vitamin B 12 refers to a group of Cobalt-containing corrinoids known as cobalamins. It is also called antipernicious- anemia factor, extrinsic f

What do you mean by tympanum, Q. What is the tympanum? In which part of the...

Q. What is the tympanum? In which part of the ear is it located and what is its function? The tympanum (or ear drum) is a membrane located in the middle ear just after the audi

Diagnosis of meningitis, Diagnosis Lumbar puncture is done which shows...

Diagnosis Lumbar puncture is done which shows cloudy CSF with increased pressure, the white cell count predominantly contains neutrophils. CSF proteins are increased but sug

Explain process of determination of vitamin B6, Explain process of Determin...

Explain process of Determination of vitamin B 6 Colorimetric determination of indophenol dye using 2,6-dichloroquinone chloraimide as colour reagent or diethyl-p-phenylenediam

Is cancer a disease transmitted to the individual offspring, How are mutage...

How are mutagenic agents related to cancer incidence in a population? Is cancer a disease transmitted to the individual offspring? The exposition of a population to mutagenic a

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