title: Parallel execute oracle PL/SQL
body: <p>Basically I have a package in oracle 11g processing a file and validating and inserting information in multiple tables, 
      to achiev this I create a stored procedure that reads the file and spread the information, then I call multiple stored procedures to
      validate and insert the data in each table (one procedure per table), for errors each SP insert a record in a common error table, at the end, 
      I call one last stored procedure that identifies if there is errors in the common error table and generate a file with those errors.</p>
  
  <p>Now... I'm trying to improve the code in order to minimize times of execution, then I realice that each SP that validates and insert info
      into table does not depend from other SP information, so I'm asking if there is a way to call all this SP in parallel.</p>
  
  <p>TODAY</p>
  
  <pre><code>STORED PROCEDURE charge_file
  STORED PROCEDURE insert_table1
  STORED PROCEDURE insert_table2
  STORED PROCEDURE insert_table3 ...
  STORED PROCEDURE return_file
  </code></pre>
  
  <p>What I am trying to do</p>
  
  <pre><code>STORED PROCEDURE charge_file
  STORED PROCEDURE insert_table1 - STORED PROCEDURE insert_table2 - STORED PROCEDURE insert_table3 ...
  STORED PROCEDURE return_file
  </code></pre>