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

On Tue, 07 Mar 2006 16:06:40 +0000, Delio Nasso wrote:

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

Nowhere in PL/SQL is there an implied commit. You need to code it into your routine.

There is a commit built in the beginning of every DDL (CREATE, DROP, etc.)

In your example there is no commit after p2 unless you code it into p3 or the '...' section. Or unless you have DDL in p3 or the '...' section.

However, the parent environment, such as SQL*Plus or Toad, is free to force a commit when *p1* completes. That has nothing to do with PL/SQL and everything to do with the host environment.

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