Download a Job Output BLOB

Use this API to download a job output BLOB.

Name

CDR_PUB_EXE_EXTERNAL.DownloadTempBlob

Signature

FUNCTION DOWNLOADTEMPBLOB( 
  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, 
  PI_NOBJID  IN    NUMBER, 
  PO_VFILENAME  OUT    VARCHAR2 
) RETURN BLOB; 

Return

Type BLOB

Description returns the output file as a BLOB.

Parameters

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

• PI_NOBJID (Mandatory) Enter the tmp_blob_id of the job output LOB. You can use the following query to get this ID:

  SELECT tmp_blob_id FROM cdr_temp_blobs_v WHERE job_id = pi_nJobId;

• PO_VFILENAME (Mandatory) This Out parameter contains the file name of the downloaded LOB file.