Results 1 to 2 of 2

Thread: How to access an Oracle Array of Number as output parameter in a stored procedure

  1. #1
    Join Date
    Apr 2010
    Posts
    5

    Default How to access an Oracle Array of Number as output parameter in a stored procedure

    Hi,
    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?

    thanks

  2. #2
    Join Date
    Aug 2004
    Posts
    1,108

    Default

    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
    Thomas Risberg
    SpringSource by Pivotal
    http://www.springsource.org

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •