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
Q. ST-segment depression after  hyperventilation? Patients with abnormal autonomic drive have demonstrated ST-segment depression after hyperventilation as well as after exercis

Q. What is Biological Contaminants? You may recall reading about food borne diseases caused by the consumption of contaminated food items in the last unit. In the

What is a genotype? What is the difference between genotype and phenotype? Genotype is the genes, DNA nucleotide sequences have in the chromosomes of an individual that conditi

Q. Describe the complex spatial patterns of biodiversity? To describe the complex spatial patterns of biodiversity, ecologists and biogeographers have found it useful to expres

The various organs involved  in  the digestion process are: Alimentary tract which  includes mouth, pharynx, esophagus stomach, small intestine, large intestine, appendix,  rec

Explain Acute Renal failure Acute Renal failure:  Renal failure associated with burns or other trauma or with sharp infection or obstruction of the urinary tract.

differences between acoelomate,coelomate and pseudocoelomate

Besides the XY system are there other sex determination systems? A few animals have a sex determination system different from the XY system such as the X0 system is the sex det

In the eukaryotes, eukaryotic release factor eRF-1 recognizes all three termination codons that are UGA UAA, and UAG and, with the help of protein eRF-3, terminates translation.

what are the excretory organ of protozoa ?