Could you paste parameterMap definition ?
2009/5/4 Bhaarat Sharma <bhaara...@gmail.com>: > 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! >
