title: How to populate data into a nested table in Oracle when the nested table is within a record type
body: <p>I need to be able to return from a procedure a list of values in the form of a cursor variable. But within the list some fields can have multiple values</p>
  
  <p>e.g. a product can have multiple description lines in the description field (obtained from a different table).</p>
  
  <p>I was thinking in line of creating a nested table within a record type and associate this to a cursor.</p>
  
  <pre><code>TYPE N_TYPE IS TABLE OF VARCHAR2(350);
  TYPE TYPE1 IS RECORD ( FIELD_1 VARCHAR2(100)
                        , FIELD_2 VARCHAR2(30)
                        , FIELD_3 N_TYPE);
  
  TYPE T_CUR IS REF CURSOR RETURN TYPE1;
  
  Procedure p_proc (p_1 IN VARCHAR2, p_2 OUT t_cur) is
    -- processing input parameter and passing out a cursor to host application
  end p_proc;
  </code></pre>
  
  <p>Here within the procedure I will need to pass <code>p_1</code> into a table and using a explicit cursor to retrieve the data into <code>Field_1</code> and <code>Field_2</code>.</p>
  
  <p>Then from another table I will need to assign multiple records into <code>Field_3</code>.</p>
  
  <p>Can anyone show me how to populate data into a nested table when the table is part of a datatype within a record? And how do I check once it has been populated. And how to assign this back to a cursor variable for the out parameter?</p>