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
LOOP Statements The LOOP statements execute a series of statements at multiple times. The loops enclose the series of statements that is to be repeated. The PL/SQL provides typ

Data Types in SQL - Character CHARACTER or, synonymously, CHAR, for character strings. When this type is to be the declared type of something (e.g., a column), the permissible

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

Recursive Subprograms The recursive subprogram is the one that calls itself. Think of a recursive call as a call to a few other subprograms that does the similar task as your

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

SQL Functions The PL/SQL uses all the SQL functions involving the following aggregate functions that summarize the whole columns of the Oracle data: GROUPING, AVG, COUNT, STDDE

ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

Question 1 . Compare SQL and PL/SQL Question 2 . Write a database trigger to implement the following check condition                          Given the following table

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec