title: Parallel Execution of Stored Procedure in Oracle
body: <p>I have one package contains many Stored Procedure for populating diffrent tables.
  This package is being called at the time of Uplaod of one Excel file.
  Now suppose i have five procedure SP1,SP2,SP3,SP4,SP5 inside a package PKG</p>
  
  <pre><code>    Create or replace  package PKG
  declare
      begin 
      sp1;
      sp2;--shd run without waiting for SP1 to get finish..
      sp3;--shd run without waiting for SP2 to get finish..
      sp4;--shd run without waiting for SP3 to get finish..
      sp5;--shd run without waiting for SP4 to get finish..
      end;
  </code></pre>
  
  <p>Now what i want is to execute all SP together tat means SP2 shd not wait for SP1 to get complete..
  Is there any way to do like this "parallel execution of procedures"..</p>
  
  <p>I am using PL/SQL oracle 9i/10g</p>
  
  <p>Thanks</p>