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: Sat, 11 Mar 2006 02:53:25 GMT
Message-Id: <pan.2006.03.11.02.53.27.755183@telus.net>


On Sat, 11 Mar 2006 02:39:59 +0000, ianal Vista wrote:

> "Delio Nasso" <daleanton_at_libero.it> wrote in 
> news:cbad35a0f0cb6cd1f261fc36846892b0.35030_at_mygate.mailgate.org:
> 
>>> Yes.
>>> 
>>> What problem are you trying to solve?
>>> 
>>> It depends.

>>
>> It depends on what? I only want to know if after p2 there is commit or
>> not..
>>
>>
>>
>>
> 
> If/when you see "COMMIT", then there is a commit.
> If you don't see those 6 letters, then there is no commit.

Unless ....

if you create, drop or alter in Oracle, there is a commit just before the command is invoked.

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

-- 
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 10 2006 - 20:53:25 CST

Original text of this message

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