Re: procedure submitted to dbms_job - implicit commit?

On 23 Jul, 08:33, steph <stepha..._at_yahoo.de> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

As Dan quoted from Oracle's own documentation: ""You should explicitly commit or roll back every transaction."

So, commit (or rollback, depending on your logic) as required.

HTH -g Received on Wed Jul 23 2008 - 06:25:51 CDT