Upload a LOB to a Temporary Table
Use this API to upload one or more BLOBs or CLOBs (binary or character large objects) to a temporary table.
Name
CDR_PUB_EXE_EXTERNAL.CreateTempLobs
Signature
PROCEDURE CREATETEMPLOBS( 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_BZIP IN BOOLEAN, PI_BLOBNAMES IN CDR_VC_LIST_COLL, PI_BLOBENTRIES IN CDR_BLOB_LIST_COLL, PI_CLOBNAMES IN CDR_VC_LIST_COLL, PI_CLOBENTRIES IN CDR_CLOB_LIST_COLL );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_NJOBID (Mandatory) Enter the Job_ID. You can get the Job ID by running CDR_PUB_EXE_RUNTIME.GETCURRENTLYEXECUTINGJOBID.
- PI_BZIP Is the input lobs in zip format? Enter TRUE or FALSE.
- PI_BLOBNAMES This parameter is of type cdr_vc_list_coll which is a collection of varchar2(2000). The varchar contains the BLOB file name.
- PI_BLOBENTRIES This parameter is a collection of cdr_blob_list_coll which is a collection of BLOB types. This parameter contains the actual file BLOBs. This is always a collection so even if you are uploading a single CLOB, initialize the collection with that BLOB and pass it here.
- PI_CLOBNAMES This parameter is of type cdr_vc_list_coll which is a collection of varchar2(2000). The varchar contains the CLOB file name.
- PI_CLOBENTRIES This parameter is a collection of cdr_clob_list_coll which is a collection of CLOB type. This contains the actual file CLOBs. This is always a collection so even if you are uploading a single CLOB, initialize the collection with that CLOB and pass it here.
Parent topic: Create and Execute Output LOBs