Using autonomous transactions, Biology

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

Posted Date: 10/5/2012 4:43:17 AM | Location : United States







Related Discussions:- Using autonomous transactions, Assignment Help, Ask Question on Using autonomous transactions, Get Answer, Expert's Help, Using autonomous transactions Discussions

Write discussion on Using autonomous transactions
Your posts are moderated
Related Questions
Habits of patients- Implants Smoking has been shown to predispose to poor bone quality by reduced vascularity. Therefore it is prudent not to accept heavy smokers as implant pa

write about asexual reproduction in mucor

Q. Principles of Binomial Nomenclature? There are certain, basic principles of binomial nomenclature which are as follows: i) Different nomenclatural systems are independent

Discuss about electric field The electric field is a vector quantity whose magnitude is the force per unit charge and points in the direction of the force on the positive test

Explain the chemical properties of milk Autoclaving milk, wherein temperature of around 121 o C is achieved, causes browning. The brown colour is due to the heat effecting an i

Q. What is the name of the molecule that transports oxygen in red blood cells? The respiratory pigment of the red blood cells is hemoglobin.

How to Calculate the Requirements for the Calcium in Body? Requirements for calcium depend upon the rate at which calcium is incorporated into bone; they are therefore highest

Stratification - Aquatic ecosystems Aquatic ecosystems also exhibit marked stratification. In lake and ocean ecosystems light penetration, temperature and availability of oxyg

Explain the Manifestations of Iron Deficiency Anaemia? • Paleness of conjunctiva • Paleness of tongue • Paleness of mucosa of soft palate • Low haemoglobin • Swelling of

Explain Horizontal Full Mucoperiosteal Flaps - Endodontic Surgery      a) Also called:  Envelope flap, b) Only a Horizontal incision, without the vertical releasing incision