title: Passing array to Oracle procedure from c#
body: <p>I'm trying to pass an array to oracle procedure. I searched about it and firstly i created a type named 'dizi' (like here <a href="https://stackoverflow.com/questions/2885575/passing-an-array-of-data-as-an-input-parameter-to-an-oracle-procedure">enter link description here</a>). So it works in oracle developer. The problem is; i can't pass my c# array to procedure as a parameter. So how can i pass my array to my procedure?</p>
  
  <p>Here is my code (When i execute, oracle error says: Not all variables bound)</p>
  
  <pre class="lang-C# prettyprint-override"><code>public void InsertQuestion(List&lt;string&gt; area_list)
  {
      quest_areas = area_list.ToArray();
      command.Connection = connect;
      connect.Open();
  
      var arry = command.Parameters.Add("Areas", OracleDbType.Varchar2);
      arry.Direction = ParameterDirection.Input;
      arry.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
      arry.Value = quest_areas;
  
  
      command.CommandText ="TESTPROCEDURE(:Areas)";
      command.CommandType = CommandType.StoredProcedure;
      command.ExecuteNonQuery();
      connect.Close();
  }
  </code></pre>