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
At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Anatomy of a Command Figure, showing a simple SQL command, is almost identical to its counterpart in the theory book. The only difference arises from the fact that SQL uses a

UNION and OR - SQL SQL supports UNION explicitly but differently from the way it supports JOIN explicitly. As we have seen, JOIN is used exclusively within the FROM clause, su

Cursors The Oracle uses work areas to execute the SQL statements and to store process information. A PL/SQL construct known as the cursor. Let's you assume name a work area and

Assignments in pl/sql The Variables and constants are initialized every time a block or subprogram is entered. By default, the variables are initialized to NULL. Therefore, unle

Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become

%NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state

How Exceptions Are Raised By the run-time system, the internal exceptions are raised implicitly as are user-defined exceptions that you have related with an Oracle error number

Declaring a Cursor The Forward references are not allowed in the PL/SQL. Therefore, you must declare a cursor before referencing it in other statements. Whenever you declare a

Row Operators The Row operators return or reference the particular rows. ALL retains the duplicate rows in the result of a query or in an aggregate expression. The DISTINCT el