Implicit rollbacks, PL-SQL Programming

Implicit Rollbacks

Before execute the INSERT, UPDATE, or DELETE statement, the Oracle marks an implicit savepoint . When the statement fails, the Oracle rolls back to the savepoint. Generally, the failed SQL statement is rolled back, not the entire transaction. Though, if the statement raises an unhandled exception, the host atmosphere determines what is rolled back.

When you exit a stored subprogram with an unhandled exception, the PL/SQL does not assign values to the OUT parameters. Also, the PL/SQL does not roll back the database work completed by the subprogram.

Posted Date: 10/4/2012 5:15:56 AM | Location : United States







Related Discussions:- Implicit rollbacks, Assignment Help, Ask Question on Implicit rollbacks, Get Answer, Expert's Help, Implicit rollbacks Discussions

Write discussion on Implicit rollbacks
Your posts are moderated
Related Questions
Table Comparison - SQL The following definitions for relation comparisons: Let r1 and r2 be relations having the same heading. Then: r1 ⊆ r2 is true if every tuple of r1

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

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

SQL Database: So, an SQL database is one whose symbols are organized into a collection of tables. Now, shows an SQL table as the current value of an SQL variable, ENROLMENT, b

Updating a Variable Assignment of an attribute value in a variable of a structured type Synatx: SET SN.C = 'S2'; As in Example the entire statement is equivalent to a

Using ROLLBACK The ROLLBACK statements end the present transaction and undo any change made during the transaction. The Rolling back is helpful for two reasons. Firstly, if yo

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

COMMIT Statement The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered e

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is