title: Oracle jdbc "createArray" throws "Unsupported feature" exception while trying to pass array to prepared statement
body: <p>I am trying to pass an array to my prepared statement by doing <em><strong>createArrayOf</strong></em></p>
  
  <pre><code>val prep: PreparedStatement = con.prepareStatement("select * from SOA_WEB_USER.VOPEX where CMF_PPK_NBR in (?)")
  
  val array :Array[Object]=Array("1165006001","1165006002")
  
  val sqlArray = con.createArrayOf("VARCHAR",array) //getting the exception here 
  
  prep.setArray(1,sqlArray)
  
  val rs = prep.executeQuery()
  
  while (rs.next()) {
  
      println(rs.getObject(1))
  
  }
  </code></pre>
  
  <p>But createArrayOf method throws an error saying </p>
  
  <pre><code>Exception  thread "main" java.sql.SQLFeatureNotSupportedException:Unsupported feature   
  at Oracle.jdbc.driver.PhysicalConnection.createArrayOf(PhysicalConnection.java:8707)
  at com.testpackage.Main$.main(Main.scala:109)
  at com.testpackage.Main.main(Main.scala)    
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)     
  at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)
  </code></pre>
  
  <p>I am using the ojdbc7.jar for the jdbc connection.
  Is there anything I can do differently to pass the array to the prepared statement?</p>