Using savepoints, PL-SQL Programming

Using Savepoints

The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined in its autonomous transactions. However, the major transaction and an autonomous transaction can use similar savepoint names.

You can roll back only to savepoints marked in the present transaction. Therefore, when in an autonomous transaction, you cannot roll back to the savepoint marked in the major transaction. To do so, you should resume the major transaction by exiting the autonomous routine.

If in the main transaction, the rolling back to a savepoint marked before you started an autonomous transaction does not roll back the autonomous transaction. Keep in mind, that the autonomous transactions are fully independent of the major transaction.

Posted Date: 10/5/2012 4:52:23 AM | Location : United States







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

Write discussion on Using savepoints
Your posts are moderated
Related Questions
Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope

Project Description: I am looking to change FullCalendar to add/delete sql server data when events are removed or dropped from Calendar. Events should only be included by dra

heap sort program in pl/sql

Using Operator REF: You can retrieve refs by using the operator REF that, like VALUE, takes as its argument a correlation variable. In the illustration below, you retrieve one

Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi

Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

UTL_FILE: The Package UTL_FILE permits your PL/SQL programs to read & write operating system (OS) text files. It gives a restricted version of the standard OS stream file I/O,

EXECUTE Privilege To call an invoker-rights routine straightforwardly, the users should have the EXECUTE privilege on that routine. By yielding the privilege, you permit a user

Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta