Entering and exiting - autonomous transaction, PL-SQL Programming

Entering and Exiting

If you enter the executable part of an autonomous routine, the major transaction suspends. When you exit the routine, the major transaction resumes. To exit generally, you must explicitly commit or roll back all the autonomous transactions. If the routine (or any routine called by it) has pending transactions, and an exception is raised, the pending transactions are then rolled back.

Posted Date: 10/5/2012 4:50:06 AM | Location : United States







Related Discussions:- Entering and exiting - autonomous transaction, Assignment Help, Ask Question on Entering and exiting - autonomous transaction, Get Answer, Expert's Help, Entering and exiting - autonomous transaction Discussions

Write discussion on Entering and exiting - autonomous transaction
Your posts are moderated
Related Questions
Exceptions An exception is the runtime error or warning condition that can be predefined or user-defined. The Predefined exceptions are raised implicitly through runtime system

Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT.  A screen dump of the output is acceptable. Show as many rows as you can. A screen dump i

Using Invoker Rights: By default, the stored procedure executes with the privileges of its definer, not its invoker. These procedures are bound to the schema in which they inh

Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i

Using %TYPE The %TYPE attribute gives the datatype of a variable or the database column. In the example below, the %TYPE gives the datatype of a variable: credit REAL(7,2); debi

Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

Example of WHEN or THEN Constraints A concrete example showing how SQL supports WHEN/THEN constraints CREATE TABLE SAL_HISTORY (EmpNo CHAR (6), Salary INTEGER NOT NULL,

FORALL Statement The FORALL statements instruct the PL/SQL engine to bulk-bind the input collections before sending them to the SQL engine. Though the FORALL statement consists

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

Using the Collection Methods The collection methods below help to generalize the code and make collections easier to use and also make your applications easier to maintain: