Last updated on NOVEMBER 18, 2016
Applies to:Oracle Life Sciences Data Hub - Version 2.4.6 and later
Information in this document applies to any platform.
Our requirement is to submit an LSH program and wait for its completion before continuing to the next step.
To achive this we use the <cdr_pub_exe_submission.createSubmission> FUNCTION by passing the required RUNTIME parameters and setting the execution mode to "Deferred".
Once the submission is created, we call the <cdr_pub_exe_submission.startJob> PROCEDURE that submits the job, waits for it completion before the control is returned to the calling program.
Since we have to submit this procedure with the same set of parameters multiple time, we have to modify the system parameters, "Force Execution Flag", and set its value to "Yes".
The <cdr_pub_exe_submission.createSubmission> FUNCTION does not accept SYSTEM parameters, so we used the <cdr_pub_exe_submission.createSubmission> PROCEDURE, that accepts both RUNTIME and SYSTEM parameters.
This createSubmission PROCEDURE behaves differently from the FUNCTION with the same name. The problem is that this createSubmission PROCEDURE does not accept any execution mode parameter and is submitting the job into the job queue, due to
which we are unable to wait for the job to complete before continuing to the next step.
We need another procedure or function that accepts SYSTEM parameters and also allows selecting the execution mode.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms