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

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Tue, 07 Mar 2006 15:57:32 GMT
Message-ID: <Xns977F50D3FA0C1ianalvistahotmailcom@70.169.32.36>

"Delio Nasso" <daleanton_at_libero.it> wrote in news:37eb2673c98d74318490d162dc8391bb.35030_at_mygate.mailgate.org:

> Hi,
> excuse me for the simplicity of the question but I'm a beginner..
> I have seen somethings similar in this forum.
> If i have a procedure plsql that calls an other one like this:
>
> CREATE OR REPLACE PROCEDURE p1
> as
> begin
> p2();
> p3();
> ...
> end;
>
>
> After p2 is there a commit or it is after end?

Yes.

What problem are you trying to solve?

It depends. Received on Tue Mar 07 2006 - 09:57:32 CST