Sep 28th, 2011, 04:30 PM
How to access an Oracle Array of Number as output parameter in a stored procedure
I have a Oracle Strored procedure that returns a output parameter which is an Array of numbers.
O_ACCOUNT_NBR NUMBER_ARRAY OUT
Now, I need to access this in Java using Spring. I am currenly using org.springframework.jdbc.object.StoredProcedure, to execute stored procedures. How do I access this Array of numbers?
Oct 21st, 2011, 12:14 AM
The Spring Data JDBC Extensions project has some features that could help with this. Take a look at http://www.springsource.org/spring-data/jdbc-extensions