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.
Parent topic: Create and Modify Tables