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 the position of the endospore, Explain the Position of the endospor...

Explain the Position of the endospore? Endospore cannot be stained by ordinary methods such as simple staining and gram staining because these dyes do not penetrate the wall of

Why fish and sea foods are important for human body, Why Fish and Sea Foods...

Why Fish and Sea Foods are important for human Body? They are rich sources of proteins (20-25%) of a high biological value. Dry fishes contain more (60%) proteins since most of

Phylum protozoa, PHYLUM  PROTOZOA Definition  and  Introduction  ...

PHYLUM  PROTOZOA Definition  and  Introduction  All  unicellular ( or  acellular )  eukaryotic  animals. Most  primitive (Gr. Protos = first=zoon= animals ) organisms

Define foaming properties of proteins, Define Foaming Properties, Binding o...

Define Foaming Properties, Binding of Flavour and Other Substances? To understand the foaming properties of proteins, we need to know some basic aspects of foam foods. Foam foo

Explain in brief about the neuropsychological test batteries, Explain in br...

Explain in brief about the neuropsychological test batteries Neuropsychological tests have the same standardisation requirements as all psychological tests. That is, there is t

Types of parthenocarpy, Types of Parthenocarpy Three types of Partheno...

Types of Parthenocarpy Three types of Parthenocarpy are generally recognized: Genetical Environmental, Chemically-induced. Genetical Parthe

Explain phylum-bacteria, Phylum-Bacteria (Eubacteria) Eubacteria,th e t...

Phylum-Bacteria (Eubacteria) Eubacteria,th e true bacteria, are extremely small and they exist in vast numbers virtually everywhere on earth. They range from the upper atmosphe

Explain nephrotoxicity, Explain Nephrotoxicity Nephrotoxicity is the ma...

Explain Nephrotoxicity Nephrotoxicity is the major dose-limiting toxicity of amphotericin B deoxycholate; sodium loading with  normal saline may prevent or ameliorate it and is

Physiognomy and pattern, Physiognomy and Pattern Physiognomy is the g...

Physiognomy and Pattern Physiognomy is the general appearance of vegetation as determined by the growth, form of dominant species. It may be considered a synthetic character

Pulses - hypertension, Pulses Careful examination of both upper and lo...

Pulses Careful examination of both upper and lower limb pulses is useful in detecting coarctation, and other arterial stenosis. The carotid arteries should be checked for sten

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