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

Ask an Expert

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

Write your message here..

Related Questions

Theory of spontaneous generation - origin of life, THEORY OF SPONTANEOUS GE... THEORY OF SPONTANEOUS GENERATION - ABIOGENESIS OR AUTOGENESIS - According to this theory, the existing living communities have originated from non-living organic matter with

Row operators - sql operators, Row Operators The Row operators return ... 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

Loop labels- iterative control, Loop Labels Like the PL/SQL blocks, loop... Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP

Database Management, Due to an increase in overhead costs, the buying price... Due to an increase in overhead costs, the buying price of all items needs to be increased. Management wants to see a report before deciding how much each product will go up. Add to

Relational algebra - sql, Relational Algebra - SQL It describes some ... Relational Algebra - SQL It describes some operators, that together constitute an algebra that is not only relationally complete but also irreducibly so (very nearly- apart f

Calling constructors in pl sql, Calling Constructors: The Calls to a c... Calling Constructors: The Calls to a constructor are allowed wherever the function calls are allowed. Similarly to the functions, a constructor is called as a section of an ex

Query, ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quan... ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quantity BEGIN INSERT INTO bb_basketitem VALUES (88,8,10.8,21,16,2,3); END; Brewbean’s wants to add a check

Sql database, SQL Database: So, an SQL database is one whose symbols a... 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

Pl/sql assignment, 1. a. Write a trigger that fires when a part's price... 1. a. Write a trigger that fires when a part's price is updated. The trigger will write a record into a table called PriceUpdates. The record should contain the information of

Null statement-sequential control, NULL Statement The NULL statement c... NULL Statement The NULL statement clearly specifies in action; it does nothing other than to pass control to the next statement. It can, though, improve the readability. In a