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
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 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 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

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 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: 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

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: 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

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 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