Advertisement
Guest User

Untitled

a guest
Apr 7th, 2020
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.33 KB | None | 0 0
  1.     BEGIN
  2.         CLIENTS := F_VIP_CYCLE_GET_CLIENTS_INFO();
  3.         IF (CLIENTS IN SCHEMA1) DBMS_JOB.submit(l_jobno, 'begin mt1.other_proc; end;' );
  4.         IF (CLIENTS IN SCHEMA2) DBMS_JOB.submit(l_jobno, 'begin mt2.other_proc2; end;' );
  5.         IF (CLIENTS IN SCHEMA3) DBMS_JOB.submit(l_jobno, 'begin mt3.other_proc3; end;' );
  6.     END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement