I am trying to mold my code so it works with oracle stored procedures. The SP will return multiple resultsets (cursors) and will also take in a parameter. I was looking at the following example on the wiki.
http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=5653 I have two questions: - How can I mold this example so that if SP is expecting 1 input parameter then the code should work. I did the following: changed { ? = call refs_pck.get_refs } TO { ? = call refs_pck.get_refs (?)} The above does not seem to work I get the following error: Caused by: java.sql.SQLException: ORA-06550: line 1, column 13: PLS-00306: wrong number or types of arguments in call to 'GET_REFS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored - After the above works...how can i change it so that it can be used when stored procs return multiple resultsets. Because '? = XXX' means it is taking care of just one result set. Thanks!
