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

Possible errors in drug administration, POSSIBLE ERRORS IN DRUG ADMINISTRAT...

POSSIBLE ERRORS IN DRUG ADMINISTRATION There can be various reasons for error in administering drugs: i) Poor communication of intention by the prescriber. ii) Failur

Palpation , Palpation: Use the ball of one hand  and move the hand  from ...

Palpation: Use the ball of one hand  and move the hand  from one side of the posterior thorax to other. Note presence of swelling, masses, muscle tone, fremitus and crepitation.

Clinical symptoms of hiv, Clinical symptoms of HIV Generally, a person ...

Clinical symptoms of HIV Generally, a person infected with HIV does not show any apparent symptoms for a number (3 to 12) of years. Ten to fifteen percent infected people may,

Types of cardiac dopler, There are two types of Doppler examination: 1) ...

There are two types of Doppler examination: 1)  Pulse wave Doppler 2)  Continuous wave Doppler Both these modalities are necessary part of Doppler echocardiography and pro

Comparative picture of ecosystem, Q. Comparative picture of ecosystem? ...

Q. Comparative picture of ecosystem? An ecosystem having higher diversity means the number of species and interactions between them which constitute the food web, is large. In

Why red-green colour blindness is x-linked recessive, Red-green colour blin...

Red-green colour blindness is X-linked recessive. A woman with normal colour vision has a father who is red-green colour-blind. The woman has four sons, none of whom are colour-bli

How water balance take place in human body, How Water Balance Take Place in...

How Water Balance Take Place in Human Body? The amount of fluid in the body is tightly controlled because imbalance can be devastating. In a normal individual, the maintenance

Chambers of heart, The ventricles are separated from each other by the inte...

The ventricles are separated from each other by the interventricular septum and the atria are separated from each other by the interatrial septum. The interior of the right atrium

Glycolipids, G L YCOLIPIDS They are lipids having sugar residues. ...

G L YCOLIPIDS They are lipids having sugar residues. Two common glycolipids are cerebrosides and gangliosides. (1) Cerebrosides They are made of amino alcohol sphi

Chronic exposure of cadmium, Q. Chronic exposure of Cadmium? An increa...

Q. Chronic exposure of Cadmium? An increase in the soil cadmium content due to soil pollution by industrial wastes, burning of coal, fossil fuels, sewage sludge, medical and

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