title: How to populate an array in an oracle stored procedure?
body: <p>How to use array( Varray) in store procedure.  Actually,i have make a stored procedure from which i retrieve a list of elements.</p>
  
  <p>For example:</p>
  
  <pre><code>create or replace procedure GetTargetFields ( fileformat  in varchar2,
                                                filefields out Varray(4) )
  IS
  
  BEGIN
  
   SELECT id 
     INTO filefields  
     FROM tablename;
  
  END;
  </code></pre>