Re: will a job do an implicit COMMIT?

From: <>
Date: Thu, 09 Oct 2008 06:39:53 +0200
Message-ID: <>

On Thu, 09 Oct 2008 00:33:35 GMT, wrote:

>I have a job that calls a stored procedure, specified
>like this:
> job_type => 'PLSQL_BLOCK',
> job_action => 'begin qrunner_util.purge; end;',
>Will the job system perform a COMMIT after it performs the
>action? Or should I add the commit to the action:
> job_action => 'begin qrunner_util.purge; commit; end;',
>Many TIA!

What will the job do?
It will exit!
What will an exit do?
Please consult your documentation.
Please don't ask rhetorical questions.
OF COURSE the job will do a commit!

You have been here just too long to still be asking this type of question, and in the wrong forum too.

Sybrand Bakker
Senior Oracle DBA
Received on Wed Oct 08 2008 - 23:39:53 CDT

Original text of this message