Multidomain MDM
- Multidomain MDM H2L
- All Products
DECLARE IN_ROWID_TABLE VARCHAR2(14); IN_USER_NAME VARCHAR2(50); OUT_ERROR_MESSAGE VARCHAR2(1024); OUT_RETURN_CODE NUMBER; BEGIN IN_ROWID_TABLE := NULL; IN_USER_NAME := 'myusername'; OUT_ERROR_MESSAGE := NULL; OUT_RETURN_CODE := NULL; CMXMA.KEY_MATCH (IN_ROWID_TABLE, IN_USER_NAME, OUT_ERROR_MESSAGE, OUT_RETURN_CODE); DBMS_OUTPUT.PUT_LINE (' Row id table = ' || IN_ROWID_TABLE); CMXMA.KEY_MATCH ( IN_ROWID_TABLE, IN_USER_NAME, OUT_ERROR_MESSAGE, OUT_RETURN_CODE); 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; END;