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

Methods of evaluation, METHODS OF EVALUATION: The two main areas of ev...

METHODS OF EVALUATION: The two main areas of evaluation include a) evaluation of  job performance of individual b) evaluation  of programme  agency  1)  Evaluation of  the

Zoloogy, two main evolutionary novelties presented by annelids

two main evolutionary novelties presented by annelids

Traumatic reticuloperitonitis (trp), Tr aumatic reticuloperitonitis (TRP) ...

Tr aumatic reticuloperitonitis (TRP) It is also known as traumatic gastritis, hardware disease or traumatic reticulitis. Et i o l o g y : Frequentl

Role of biotic factors inducing senescence, Role of Biotic Factors Inducing...

Role of Biotic Factors Inducing Senescence Besides environmental and endogenous factors, biotic factors also play a role in inducing senescence. For example, due to an attack

Determine the posterior superior alveolar nerves, Determine the posterior s...

Determine the posterior superior alveolar nerves The anterior, middle and posterior superior alveolar nerves run in the facial wall of the maxillary sinus between its lining me

Nature and structure of community, Nature and Structure of Community E...

Nature and Structure of Community Every place on earth -grasslands, forests, and ponds, edge of the river or sea is shared by many coexisting organisms. Plants, animals and mi

Explain the differance between pinocytosis and phagocytosis, Explain the di...

Explain the differance between Pinocytosis and Phagocytosis? Pinocytosis and Phagocytosis : The cell membrane occasionally invaginates or indents to capture extracellular flu

Angiosperm, What is morphological nature of angiosperm

What is morphological nature of angiosperm

Examine the benefits and risks bird flu, Examine the benefits and risks bir...

Examine the benefits and risks bird flu research poses to society. Indicate if you believe there are more benefits or more risks associated with this research, and give a rationale

Chordates and non chordates, give an account of ciliary and flagellar move...

give an account of ciliary and flagellar movement in protozoa

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