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
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 aut

Seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of client(s) information (i.e. Name, Account Number, Address etc.) int

Creating and Destroying Base Tables: Example shows an SQL command to create the base table counterpart of the ENROLMENT variable Example  Creating a base table. CREATE T

what is the use of declare keyword

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v

Parameter and Keyword Description: type_name: This identifies a user-defined type specifier that is used in the subsequent declarations of the objects. AUTHID Clause:

GOTO Statement The GOTO statement branches to a label unconditionally. The label must be exclusive within its scope and should precede an executable statement or a PL/SQL block.

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no

Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM