Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: if I call a plsql is there a commit?
"ianal Vista" <ianal_vista_at_hotmail.com> wrote in message
news:Xns977F50D3FA0C1ianalvistahotmailcom_at_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.
Actually, neither.
In PL/SQL there are ***no*** commits unless the developer codes a commit. however, the calling environment may be configured or designed to automatically commit
however, when called from mod_plsql, there is a commit after the main procedure (whatever was invokded via http) successfully completes. but that is a characteristic of mod_plsql, not PL/SQL itself.
best way to find out (and learn for sure) ... try it (test, test, test, test, and test again).
++ mcs Received on Tue Mar 07 2006 - 10:22:57 CST