0 Replies Latest reply on Feb 28, 2003 5:52 PM by Darrel Riekhof

    passing arrays as input params with oracle

    Darrel Riekhof Newbie

      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