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 Match Jobs

Sample Job Execution Script for Match Jobs

DECLARE    IN_ROWID_TABLE CHAR(14);    IN_USER_NAME VARCHAR2(50);    OUT_ERROR_MSG VARCHAR2(1024);    RC NUMBER;    IN_VALIDATE_TABLE_NAME VARCHAR2(30);    IN_MATCH_ANALYZE_IND NUMBER;    IN_MATCH_SET_NAME VARCHAR2(500);    IN_JOB_GRP_CTRL CHAR(14);    IN_JOB_GRP_ITEM CHAR(14); BEGIN    IN_ROWID_TABLE := NULL;    IN_USER_NAME := NULL;    OUT_ERROR_MSG := NULL;    RC := NULL;    IN_VALIDATE_TABLE_NAME := NULL;    IN_MATCH_ANALYZE_IND := NULL;    IN_MATCH_SET_NAME := NULL;    IN_JOB_GRP_CTRL := NULL;    IN_JOB_GRP_ITEM := NULL; CMXMA.MATCH ( IN_ROWID_TABLE, IN_USER_NAME, OUT_ERROR_MSG, RC, IN_VALIDATE_TABLE_NAME, IN_MATCH_ANALYZE_IND, IN_MATCH_SET_NAME, IN_JOB_GRP_CTRL, IN_JOB_GRP_ITEM ); DBMS_OUTPUT.PUT_LINE ('OUT_ERROR_MESSAGE = ' || OUT_ERROR_MESSAGE); DBMS_OUTPUT.PUT_LINE ('RC = ' || TO_CHAR(RC)); IF RC < 0 THEN ROLLBACK; ELSE COMMIT; END IF; END;

0 COMMENTS

We’d like to hear from you!