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 work of john ray in animal taxonomy, Explain the Work of John R...

Explain the Work of John Ray in Animal Taxonomy? The first important work on both animal and plants was initiated by John Ray (1627-1705). He followed Aristotle and divided ani

Islet of langerhans, Islet of Langerhans: They are insulin-producing tissue...

Islet of Langerhans: They are insulin-producing tissues. It was discovered by Paul Langerhans in 1869. These cells are in groups and look like islands in the pancreas. There are ab

Illustrate in detail about the cell theory, Illustrate in detail about the ...

Illustrate in detail about the Cell theory All living organisms are composed of cells, and they are the basic structural and functional units of life, just like the atom is a

Animal food, Domesticated animals provide much of the world's meat products...

Domesticated animals provide much of the world's meat products today, but wildlife still constitutes to be an imp ortant source of food of many rural communities. The International

What are the major functions of the blood, Q What are the major functions o...

Q What are the major functions of the blood? The blood is a means of substance transportation throughout the body. The blood distributes hormones, nutrients, oxygen, cells and

Post-operative care of cardiac surgical patients, POST-OPERATIVE CARE OF PA...

POST-OPERATIVE CARE OF PATIENTS The first few days following cardiac operations are the most critical in terms of the patient's survival. The safety with which a patient can

What is palliative outflow patch, What is Palliative Outflow Patch ? Br...

What is Palliative Outflow Patch ? Brock described closed pulmonary valvotomy and infundibular resection using a punch on a beating heart. When both pulmonary arteries are not

What are examples of the ecological and economic, What are examples of the ...

What are examples of the ecological and economic importance of molluscs? Molluscs are significant players in several food chains in ecosystems. Many marine molluscs are part of

Lower oesophageal sphincter, Q Lower Oesophageal Sphincter? Competency ...

Q Lower Oesophageal Sphincter? Competency of LES (Lower Oesophageal Sphincter) is important. The pressure of this sphincter is controlled by many factors, one of which is hormo

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