Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- CLIENTS := F_VIP_CYCLE_GET_CLIENTS_INFO();
- IF (CLIENTS IN SCHEMA1) DBMS_JOB.submit(l_jobno, 'begin mt1.other_proc; end;' );
- IF (CLIENTS IN SCHEMA2) DBMS_JOB.submit(l_jobno, 'begin mt2.other_proc2; end;' );
- IF (CLIENTS IN SCHEMA3) DBMS_JOB.submit(l_jobno, 'begin mt3.other_proc3; end;' );
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement