MULTITHREADING IN PLSQL

MULTITHREADING IN PLSQL

PLSQL doesn't support Multithreading features. However, if you would like to use multithreading in plsql means The conventional solution is to use DBMS_JOB or DBMS_SCHEDULER.

declare
  ln_dummy number;
begin
  DBMS_JOB.SUBMIT(ln_dummy, 'begin myProc(1,100); end;');
  DBMS_JOB.SUBMIT(ln_dummy, 'begin myProc(101,200); end;');
  DBMS_JOB.SUBMIT(ln_dummy, 'begin myProc(201,300); end;');
  COMMIT;
end;