Get a Table Instance ID
Use this API to get the Object ID of the table instance that is mapped to a particular table descriptor. You can invoke this function within a PLSQL program.
While transforming source data into target data in Oracle DMW, it is needed at times, to flag target data. The Oracle DMW API used to assign flags to target data requires the Obj ID of the Table Instance as input. This API performs the task of getting the required Obj ID of the target Table Instance, in order that the Flag-related Oracle DMW APIs can be invoked.
Name
CDR_PUB_DF_MAPPING.Get_Tab_Inst_ID
Signature
FUNCTION GETTABINSTID( PI_TABDESCNAME IN VARCHAR2, )RETURN NUMBER;
Return
Type NUMBER
Parameters
This API has the following parameter:
PI_TABDESCNAME (Mandatory). Enter the Oracle Name of the Table Descriptor whose mapped Table Instance ID you want to retrieve.
Parent topic: Create and Modify Mappings