title: How can we pass array to SQL server stored procedure using JAVA?
body: <p>I want to call sql server stored procedure by passing array_list.</p>
  
  <pre><code>String[][] array1=new String[2][2];
  array1[0][0]="a";
  array1[0][1]="b";
  array1[1][0]="c";
  array1[1][1]="d";
  String name="TEST";
  String SPsql="EXEC SP_name ?,?,?";
  PreparedStatement stmt=con.preparedStatement(SPsql);
  stmt.setString(1, name);
  stmt.setArray(2,array1);
  </code></pre>
  
  <p>The last line is giving error. not able set array there.
  I tried with list also but no use.</p>