 | |
will a job do an implicit COMMIT?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
will a job do an implicit COMMIT? -
10-08-2008
, 07:33 PM
#2
| |||
| |||
|
|
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? |
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
#3
| |||
| |||
|
|
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? |
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
#4
| |||
| |||
|
|
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? |
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
#5
| |||
| |||
|
|
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? |
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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.