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

Sample Job Execution Script for Synchronize Jobs

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'; CMXUT.SYNCH (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); IF OUT_RETURN_CODE < 0 THEN ROLLBACK; ELSE COMMIT; END IF; END;

0 COMMENTS

We’d like to hear from you!