Upload an Output BLOB

Use this API to upload an output BLOB generated by an external processing engine into Oracle LSH.

Name

CDR_PUB_EXE_EXTERNAL.UploadBlobOutput

Signature

PROCEDURE UPLOADBLOBOUTPUT( 
  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    VARCHAR2, 
  PI_VFILENAME  IN    VARCHAR2, 
  PI_NPRREFID  IN    VARCHAR2, 
  PIO_BLOBSTREAM  IN OUT    BLOB 
); 

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PI_NJOBID (Mandatory) Enter the JOB_ID of the job that generated the output.
• PI_VFILENAME (Mandatory) Enter the filename associated with the Planned Output.
• PI_NPRREFID (Mandatory) Enter the PRREF_ID of the Oracle LSH executable. This attribute is available from the cdr_jobs_v view.
• PIO_BLOBSTREAM (Mandatory) This is a parameter of type BLOB. Enter BLOB to be uploaded.