Transaction context, PL-SQL Programming

Transaction context

As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one autonomous routine calls the other (or itself recursively), the routines distribute no transaction context. Though, if an autonomous routine calls a non-autonomous routine, the routines share the similar transaction context.

1148_transaction context.png

Figure: Transaction Context

Posted Date: 10/5/2012 4:47:40 AM | Location : United States







Related Discussions:- Transaction context, Assignment Help, Ask Question on Transaction context, Get Answer, Expert's Help, Transaction context Discussions

Write discussion on Transaction context
Your posts are moderated
Related Questions
Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

Cursor Attributes   The Cursors and cursor variables have 4 attributes which give you helpful information about the execution of a data manipulation statement. Syntax:

Project Description: This is stage 1 of a larger conversion project. We are converting a traditional Server/Client application written in Access 2007 into a web interface with S

Ensuring Backward Compatibility   The PL/SQL Version 2 permits some abnormal behavior which Version 8 disallows. Particularly, Version 2 permits you to (i) Make the forw

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

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

Use of Table Expressions - Expressing Constraint Conditions With the exception of key constraints, the examples in the theory book all explicitly reference at least one relvar

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh