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.