Re: will a job do an implicit COMMIT?

On Thu, 09 Oct 2008 00:33:35 GMT, mh_at_pixar.com 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!
>Mark

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