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

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

what is the use of declare keyword