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
ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

3CX PBX sync Windows Service Project Description: !! You require access to a commercial version of the 3CX PBX system in order to be able to program the API !! !! You requ

Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Example of Tables within a Table - SQL Example: Obtaining C_ER from COURSE and EXAM_MARK SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM_MARK AS EM

Due to an increase in overhead costs, the buying price of all items needs to be increased. Management wants to see a report before deciding how much each product will go up. Add to

Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

Comparison Operators Usually, you use the comparison operators in the WHERE clause of a data manipulation statement to form the predicates, that compare one expression to anot

OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a