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
THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Managing Cursors The PL/SQL uses 2 types of cursors: implicit and explicit. The PL/SQL declares a cursor implicitly for all the SQL data manipulation statements, including th

Use of Table Comparisons - SQL Table comparisons where it is noted that although table expressions cannot be compared, we have TABLE (t) to convert a table expression t into

MAX and MIN operator in SQL Example: (SELECT MAX (Mark) FROM EXAM_MARK WHERE StudentId = 'S1') (SELECT MIN (Mark) FROM EXAM_MARK WHERE StudentId = 'S1') Example

Data Types in SQL - Interval, Boolean INTERVAL for values denoting, not intervals (!) but durations in time, such as 5 years, 3 days, 2 minutes, and so on. BOOLEAN, con

Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no