Committing and rolling back - autonomous transaction, PL-SQL Programming

Committing and Rolling Back

The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends, the next SQL statement begins the other transaction.

1973_multiple autonomous transaction.png

Figure: Multiple Autonomous Transactions 

Posted Date: 10/5/2012 4:51:49 AM | Location : United States







Related Discussions:- Committing and rolling back - autonomous transaction, Assignment Help, Ask Question on Committing and rolling back - autonomous transaction, Get Answer, Expert's Help, Committing and rolling back - autonomous transaction Discussions

Write discussion on Committing and rolling back - autonomous transaction
Your posts are moderated
Related Questions
Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v

When Are Constraints Checked Under the model constraints are conceptually checked at all statement boundaries (and only at statement boundaries). By default the same is true

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

I need SQL , WP SQL Expert Project Description: Expert required to modify WP SQL query. Skills required are MySQL, SQL, PHP, Wordpress

Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e

Example of GROUPBY Operator Example: How many students sat each exam, using GROUP BY, NATURAL LEFT JOIN, and COALESCE SELECT CourseId, COALESCE (n, 0) AS n FROM COURS

Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

Parameter and Keyword Description: type_name: This identifies a user-defined type specifier that is used in the subsequent declarations of the objects. AUTHID Clause: