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
Albeit simple method : These all the truth tables give us our first as albeit simple method for proving a theorem: where check whether it can be written in propositional logic

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Procedures   The procedure is a subprogram which performs a specific action. You write procedures using the syntax as shown below: PROCEDURE name [(parameter[, parameter, .

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become

I want someone to write a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get information about the connection, but none of these return th

Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

Using Pragma RESTRICT_REFERENCES: The function called from the SQL statements should obey certain rules meant to control the side effects. To check for violation of the rules,