title: How load csv file to oracle table with procedure
body: <p>I try load csv data to table from stored procedure</p>
  
  <p>I have table with 3 columns: <strong>id, name and values.</strong>
  In file i have this data:</p>
  
  <pre><code>id;name;values
  1;aaa;32
  2;bbb;23
  3;cvv;12
  4;fff;54
  </code></pre>
  
  <p>Next i write code to read from file test.csv</p>
  
  <pre><code>declare
   file utl_file.file_type;
   line varchar2(500);
  begin
   file :=utl_file.fopen('DIRECTORY','test.csv','r');
  loop
   utl_file.get_line(file ,line);
   dbms_output.put_line(line);
  end loop;
  exception
   when others then
  utl_file.fclose(file );
  end;
  </code></pre>
  
  <p><strong>It works good.</strong> 
  In next step <strong>i needs insert all data from CSV to appropiate column of TABLE</strong> excluded first line. </p>
  
  <p>I try find resolve in internet, but i have still problem with this. Can you help me?</p>