title: Using PL/SQL associative arrays
body: <pre><code>create or replace aArr is TABLE of varchar2 index by binary_integer;
  create or replace bArr is TABLE of varchar2 index by binary_integer;
  
  create or replace prc(oname aArr, iname bArr) as
  begin
  
  --Now i have two arrays
  -- i want to insert or update into table using these two arrays
  -- How can i do that with out using the loops.
  -- is there any bulk insert or update.
  
  end
  </code></pre>
  
  <p>Now I have two arrays. I want to insert or update into table using these two arrays. How can I do that with out using the loops? Is there any bulk insert or update?</p>