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

Subprograms, What Are Subprograms? The Subprograms are named PL/SQL blo... What Are Subprograms? The Subprograms are named PL/SQL blocks which can take parameters and be invoked. The PL/SQL has 2 types of subprograms known as the procedure s and func

Object types - syntax, Object Types An object type is a user-defined co... Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th

Sql is a database language, SQL Is a Database Language: The commands g... SQL Is a Database Language: The commands given to a DBMS by an application are written in the database language of the DBMS. The term data sublanguage is sometimes used instea

Create a procedure that update the status, Create a procedure named STATUS_... Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Object type in pl/sql, Object Type: The object type is a user-define... Object Type: The object type is a user-defined composite datatype which encapsulates a data structure along with the functions and procedures required to manipulate the data

I need sql to infopath data connection, I need SQL to infopath data connect... I need SQL to infopath data connection Project Description: Want data retrieval connection from SQL to SharePoint infopath Skills required are Sharepoint, SQL

Using trim - collection method, Using TRIM This process has two forms.... Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.

Using for update, Using FOR UPDATE If you declare a cursor which will ... Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an

Write a pl/sql anonymous block that accepts an employee id, Based on the EM... Based on the EMPLOYEE table created in Assignment #1, write a PL/SQL anonymous block that accepts an employee ID from the user input and finds whether the employee ID is in the EMP

Initializing records, Initializing Records The illustration below show... Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp