Multidomain MDM
- Multidomain MDM H2L
- All Products
DECLARE V_ROWID_TABLE CHAR(14); OUT_ERROR_MESSAGE VARCHAR2(1024); OUT_RETURN_CODE INTEGER; BEGIN SELECT ROWID_TABLE INTO V_ROWID_TABLE FROM C_REPOS_TABLE WHERE TABLE_NAME = 'C_CUSTOMER'; CMXMA.RESET_MATCH (V_ROWID_TABLE, 'ADMIN', OUT_ERROR_MESSAGE, OUT_RETURN_CODE); DBMS_OUTPUT.PUT_LINE ('RETURN MESSAGE: ' || SUBSTR( OUT_ERROR_MESSAGE, 1, 255)); DBMS_OUTPUT.PUT_LINE ('RETURN CODE: ' || OUT_RETURN_CODE ); DBMS_OUTPUT.PUT_LINE ('OUT_ERROR_MESSAGE = ' || OUT_ERROR_MESSAGE); DBMS_OUTPUT.PUT_LINE ('RC = ' || TO_CHAR(OUT_RETURN_CODE)); IF OUT_RETURN_CODE < 0 THEN ROLLBACK; ELSE COMMIT; END IF; END;