Multidomain MDM
- Multidomain MDM H2L
- All Products
DECLARE IN_ROWID_TABLE CHAR(14); IN_SURVIVING_ROWID CHAR(14); IN_MEMBER_ROWID_LIST VARCHAR2(4000); IN_ROWID_MATCH_RULE VARCHAR2(4000); IN_COL_LIST VARCHAR2(4000); IN_VAL_LIST VARCHAR2(4000); IN_INTERACTION_ID NUMBER; IN_USER_NAME VARCHAR2(200); IN_WINNING_CELL_OVERRIDE VARCHAR2(4000); OUT_ERROR_MESSAGE VARCHAR2(200); OUT_RETURN_CODE NUMBER; OUT_TMP_TABLE_LIST VARCHAR2(32000); BEGIN IN_ROWID_TABLE := 'SVR1.CP4 '; IN_SURVIVING_ROWID := '40 '; IN_MEMBER_ROWID_LIST := '42 ~44 ~45 ~47 ~48 ~49 ~'; IN_ROWID_MATCH_RULE := NULL; IN_COL_LIST := 'SVR1.CSB ~SVR1.CSE ~SVR1.CSG ~SVR1.CSH ~SVR1.CSA ~'; IN_VAL_LIST := 'INDU~THOMAS~11111111111~F~1000~'; IN_INTERACTION_ID := 0; IN_USER_NAME := 'INDU'; IN_WINNING_CELL_OVERRIDE := NULL OUT_ERROR_MESSAGE := NULL; OUT_RETURN_CODE := NULL; CMXMM.MULTI_MERGE (IN_ROW_TABLE, IN_SURVIVING_ROWID, IN_MEMBER_ROWID_LIST, IN_ROWID_MATCH_RULE, IN_COL_LIST, IN_VAL_LIST, IN_INTERACTION_ID, IN_USER_NAME, OUT_TMP_TABLE_LIST, OUR_ERROR_MESSAGE, OUT_RETURN_CODE, IN_WINNING_CELL_OVERRIDE); DBMS_OUTPUT.PUT_LINE ('OUT_ERROR_MESSAGE = ' || OUT_ERROR_MESSAGE); DBMS_OUTPUT.PUT_LINE ('OUT_RETURN_CODE = ' || TO_CHAR(OUT_RETURN_CODE)); IF OUT_RETURN_CODE < 0 THEN ROLLBACK; ELSE COMMIT; END IF; CMXUT.DROP_TABLE_IN_LIST(OUT_TMP_TABLE_LIST, OUT_ERROR_MESSAGE,OUT_RETURN_CODE); --Clean up temporary tables END;