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
An episode of diarrhoea can be acute (recent origin) or chronic (extended duration and repeated episodes) in nature. You may recall reading in the Food Microbiology ans Safety Cour

a) Explain the polygonum type of embryo sac. Why is it generally referred to as monosporic ? b) Explain human leucocyte antigen complex? Describe its role in organ transplantati

Influenza Influenza is an acute infectious disease caused by influenza viruses of genus Orthomyxovirus in family Orthomyxoviridae. The name Influenza is derived from an Italian ph

Marine Ecosystems Marine ecosystems cover 70 per cent of the earth's surface and have an average depth of 3.750 m (the greatest known depth being 10,750 metres in the Mariana

In mountain rabbits, the EL-1 gene is located on chromosome 3. Seven alleles of this gene have been identified in the population. With respect to EL-1, what is the maximum number o

In a numeric pyramid to which trophic level does the base always refer? What about the top level? In a numeric pyramid the base corresponds to the first trophic level, i.e., to

Contact Osteogenesis: In this the osteogenic cells attach to the implant surface and the new (de novo) bone is formed on the implant surface first. The developing bone matrix can d

Gastrointestinal Antibiotic prophylaxis is recommended for esophageal surgery in the presence of obstruction, which increases the risk of infection. After gas troduodenal surge


Q Do beings of the class Reptilia have indirect or direct development? In beings of the class Reptilia the embryonic development is direct. So there is no larval stage. Q.