Re: will a job do an implicit COMMIT?
Date: Thu, 09 Oct 2008 06:39:53 +0200
On Thu, 09 Oct 2008 00:33:35 GMT, mh_at_pixar.com wrote:
>I have a job that calls a stored procedure, specified
> 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;',
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 DBAReceived on Wed Oct 08 2008 - 23:39:53 CDT