Upload a Table Descriptor or Column

Use this API to upload Columns and/or a Table Descriptor.

Name

CDR_PUB_DF_TABLE.UploadOperatorColumns

Signature

PROCEDURE UPLOADOPERATORCOLUMNS( 
  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_COMPID  IN    NUMBER, 
  PI_NSOBJID  IN    NUMBER, 
  PI_NSOBJVER  IN    NUMBER, 
  PI_OBJID  IN    NUMBER, 
  PI_OBJVER  IN    NUMBER, 
  PI_NVCOLL  IN    CDR_NAME_VALUE_PAIR_COLL 
); 

Parameters

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

• PI_COMPID (Mandatory) Enter the COMPANY_ID of the Column or Table Descriptor.
• PI_NSOBJID (Mandatory) Enter the Namespace OBJ_ID of the Column or Table Descriptor.
• PI_NSOBJVER (Mandatory) Enter the Namespace OBJ_VER of the Column or Table Descriptor.
• PI_OBJID (Mandatory) Enter the OBJ_ID of the Column or Table Descriptor.
• PI_OBJVER (Mandatory) Enter the OBJ_VER of the Column or Table Descriptor.
• PI_NVCOLL (Mandatory) This is a collection of CDR_NAME_VALUE_PAIR_OBJ_TYPE that contains name value pairs for the variable in LSH database to store the uploaded Columns and/or Table Descriptor.

  You must call CREATETEMPBLOB API before you use this API.

  For SAS/C-PORT files, the variable name is the TMP_BLOB_ID which is defined after you call CREATETEMPBLOB API. For other uploads, the variable name is NULL.