Re: psql commit

From: HansF <News.Hans_at_telus.net>
Date: Fri, 03 Mar 2006 22:32:27 GMT
Message-Id: <pan.2006.03.03.22.32.26.149095@telus.net>

On Fri, 03 Mar 2006 14:38:02 +0000, Jim Smith wrote:

> In message <pan.2006.03.02.22.01.59.382670_at_telus.net>, HansF 
> <News.Hans_at_telus.net> writes

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

>
> Surely AUTOCOMMIT in SQL*Plus issues a commit after every statement?[1]

Supporting Jim's note and comments. And confirming from the SQL*Plus Reference manual, in the description of AutoCommit:

"SET AUTOCOMMIT does not alter the commit behavior when SQL*Plus exits. Any uncommitted data is committed by default."

In any case - the host environment that calls SQL and PL/SQL is free to set the implied commit behaviour.

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

Received on Fri Mar 03 2006 - 16:32:27 CST