Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: if I call a plsql is there a commit?

Re: if I call a plsql is there a commit?

From: HansF <News.Hans_at_telus.net>
Date: Sun, 12 Mar 2006 21:46:16 GMT
Message-Id: <pan.2006.03.12.21.46.20.806597@telus.net>


On Sun, 12 Mar 2006 13:35:26 -0800, DA Morgan wrote:

> HansF wrote:
>

>> if you use SQLPLus, by default there is a commit just before you leave the
>> environment.

>
> Ouch! This requires a caveat.
>
> Provided you leave SQL*Plus cleanly and that nothing in your setup
> changes its default AUTOCOMMIT setting. That is a big caveat and will
> likely lead many to make mistakes or use bad practices.

No caveat required if one understands 'by default'. But you are correct in raising awareness of the default and exceptions.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***
Received on Sun Mar 12 2006 - 15:46:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US