I've defined an OracleDS datasouce in my oracle-service.xml and everything is working great. However, I was looking into how to pass an array to one of our stored procedures and ran into a problem. Oracle gives examples of doing this, but it assumes you have an OracleCallableStatement. We don't, we get a org.jboss.resource.adapter.jdbc.local.LocalCallableStatement
So, is it possible to pass arrays to oracle stored procs through the generic CallableStatement interface, or what is a good workaround?
Thanks, Darrel