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.
Parent topic: Create and Execute Output LOBs