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

Nucellus - ovule, Nucellus - Ovule Enclosed within the integuments li...

Nucellus - Ovule Enclosed within the integuments lies a homogenous mass of tissue which is termed as the nucellus. This is the tissue in which the female gametophyte differen

Are birds rare in polar regions, How different are reptiles and birds conce...

How different are reptiles and birds concerning the maintenance of body temperature? Are birds rare in polar regions? Reptiles are heterothermic, i.e., they do not control thei

What do you understand by hiatus hernia, Q. What do you understand by Hiatu...

Q. What do you understand by Hiatus Hernia? Several long/short term complications may arise due to GERD which may in turn increase the frequency or severity of this disease. On

What is an effect of increased temperature, What is the effect of increased...

What is the effect of increased temperature on a non enzyme catalyzed reaction? What are the effects of increased temperature on an enzyme catalyzed reaction?

Explain the objectives of nutritional care, Explain the Objectives of nutri...

Explain the Objectives of nutritional care? - To minimize the development of nutrient imbalance. - To maintain fluid and electrolyte homeostasis - To promote energy equil

Define modulation of transcription of cell cycle proteins, Modulation of th...

Modulation of the transcription of cell cycle proteins? The 1,25-(OH),D  compound (calcitriol), is present in the blood complexes to the vitamin D-binding  protein, a specific

Etiology of constipation, Q. Etiology of constipation? The etiology and...

Q. Etiology of constipation? The etiology and management of two distinct disorders of the bowel viz., diarrhoea and constipation. We small continue our discussion on certain ot

Reproduction, name the sturcture formed when the male and female nuclei fus...

name the sturcture formed when the male and female nuclei fuse during fertilisation.

Can you illustrate period of meiosis, Q. What is the crossing over? And In ...

Q. What is the crossing over? And In which period of meiosis does this event occur? Crossing over is the eventual exchange of chromosomal fragments among homologous chromosomes

Pathophysiology and medical mangement of acute renal failure, Pathophysiolo...

Pathophysiology of Acute Renal Failure It is usually reversible but the deviation of physiologic function can be extreme and mortality in pediatric age group remains high. Th

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