Re: psql commit

On Thu, 02 Mar 2006 16:27:58 -0400, tony wrote:

> I would like to know when exactly the implied commit takes place in a

The 'implied commit' is actually in the host tool, not in PL/SQL. If you run SQLPLus and Autocommit is 'ON', then the implied commit will happen coincident with a disconnect.

PL/SQL itself repects the transaction boundaries being 'transaction starts with first DML (or transaction request), and ends with an explicit commit or rollback'

A developer needs to remember that all DDL has an explicit commit just before the DDL starts.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***