title: How to pass List from java to Oracle Procedure?
body: <p>I want to send a List from java to Oracle procedure.
  Forexample,
  There is a school and the school has a list of students.
  Also, the students have a list of lectures.
  I create a list of lectures, 
  and a list of students who has the list of lectures, 
  and a school has a list of the students.</p>
  
  <p>The Lectures.</p>
  
  <pre><code>ArrayList&lt;String&gt; lecture1 = new ArrayList&lt;String&gt;();
      lecture1.add("Mat");
      lecture1.add("physics");
  
      ArrayList&lt;String&gt; lecture2 = new ArrayList&lt;String&gt;();
      lecture2.add("English");
      lecture2.add("Spanish");
  
      ArrayList&lt;String&gt; lecture3 = new ArrayList&lt;String&gt;();
      lecture3.add("Germany");
      lecture3.add("French");
  </code></pre>
  
  <p>The list of lectures.</p>
  
  <pre><code>ArrayList&lt;ArrayList&lt;String&gt;&gt; lectureList1 = new ArrayList&lt;ArrayList&lt;String&gt;&gt;();
      lectureList1.add(lecture1);
      lectureList1.add(lecture3);
  
      ArrayList&lt;ArrayList&lt;String&gt;&gt; lectureList2 = new ArrayList&lt;ArrayList&lt;String&gt;&gt;();
      lectureList2.add(lecture2);
      lectureList2.add(lecture3);
  </code></pre>
  
  <p>And the list of students who have lectures.</p>
  
  <pre><code>    ArrayList&lt;ArrayList&lt;String&gt;&gt; StudentList = new ArrayList&lt;ArrayList&lt;String&gt;&gt;();
      StudentList.addAll(lectureList2);
      StudentList.addAll(lectureList2);
  ArrayList&lt;ArrayList&lt;String&gt;&gt; StudentList2 = new ArrayList&lt;ArrayList&lt;String&gt;&gt;();
  
      StudentList2.addAll(lectureList1);
      StudentList2.addAll(lectureList2);
  </code></pre>
  
  <p>And the school</p>
  
  <pre><code>    ArrayList&lt;ArrayList&lt;ArrayList&lt;String&gt;&gt;&gt; school = new ArrayList&lt;ArrayList&lt;ArrayList&lt;String&gt;&gt;&gt;();
      school.add(StudentList2);
      school.add(StudentList);
  </code></pre>
  
  <p>i want to send "<strong>school</strong>" to an oracle procedure. However I couldn't send a list directly. Oracle library allow to send array but I want to send list.</p>
  
  <p>How can I do this operation? Could you help me.</p>
  
  <p>Thanks.</p>