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
Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 JOIN CONTRACT ON EMPLOYEE

Package STANDARD package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available a

Challenge 1 You are required to do the project and write a test plan for it. Demo 4 is a check writer program for employees. In it, the user enters all information about the

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

Keyword and Parameter Description: boolean_expression: This is an expression which results the Boolean value TRUE, FALSE, & NULL. It is related with a series of statement

ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quantity BEGIN INSERT INTO bb_basketitem VALUES (88,8,10.8,21,16,2,3); END; Brewbean’s wants to add a check

User-Defined Exceptions The PL/SQL defines the exceptions of your own. Dissimilar to the predefined exceptions, the user-defined exceptions should be declared and should be rai

Providing Results of Queries Expressing queries in SQL is the (big) subject. Here I present just a simple example to give you the flavour of things to come in those chapters.