Wait for a Job to Complete
Use this API to enable synchronous execution so that program control waits for a Job to complete before proceeding with the rest of the logic.
Name
CDR_PUB_EXE_EXTERNAL.WaitForFinalStatus
Signature
PROCEDURE WAITFORFINALSTATUS( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_NJOBID IN NUMBER, PI_NTIMEOUT IN NUMBER, PI_NSERVICEINSTANCEID IN NUMBER );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_NJOBID (Mandatory) Enter the Job ID of the Job in process. The Job_ID is returned by the API CDR_PUB_EXE_SUBMISSION.CREATE SUBMISSION and in the UI.
- PI_NTIMEOUT (Mandatory) Enter in seconds, the job completion period before the API times out.
- PI_NSERVICEINSTANCEID (Mandatory) Enter the service instance that is processing the job. Get the ID from the cdr_jobs_v view using the Job_Id.
Parent topic: Create and Execute Output LOBs