Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Writing Custom Scripts to Run Batch Jobs

Writing Custom Scripts to Execute Batch Jobs

Writing Custom Scripts to Execute Batch Jobs

Sample Job Execution Script for Multi Merge Jobs

Sample Job Execution Script for Multi Merge Jobs

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;

0 COMMENTS

We’d like to hear from you!