Re: procedure submitted to dbms_job - implicit commit?

On 22 Jul., 20:06, joel garry <joel-ga..._at_home.com> wrote:
> On Jul 22, 7:13 am, steph <stepha..._at_yahoo.de> wrote:
>
> > Hi group,
>
> > I'm just wondering - and I tried to look it up in the documentation:
>
> > When I submit a dbms_job calling a pl/sql-procedure and this procedure
> > does some data-changes - is it for sure that this changes are
> > commited? (There is no commit in the procedure.)
>
> > I've tried with a little test-case and the job's changes seem to be
> > commited - but I'm not sure if this is standard behaviour. Is it
> > possible to submit a job that does no implicit commit?
>
> Besides what Dan Blum noted, see metalink Note:61730.1.
>
>
>
> > Thanks,
> > stephan
>
> > Oh, my version of Oracle is 10g - but I assume my question is general
> > and not version-dependent ...
>
> Seehttp://www.orafaq.com/maillist/oracle-l/2005/02/09/0440.htm(I
> think there are more specific posts floating around somewhere that
> explain how things change, but that was found with a quick google).
>
> Also seehttp://www.pythian.com/blogs/398/dbms_scheduler-and-implicit-commits
>
> jg
> --
> @home.com is bogus.
> "A pilot who doesn't have any fear probably isn't flying his plane
> to its maximum." - Jon McBride, astronaut

oh thanks, that explains. but surely it's better to issue explicit commits and not to rely on the implicit one - and if it's only to make the code more readable
regards,
stephan Received on Wed Jul 23 2008 - 02:33:59 CDT