ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bhaarat Sharma <bhaara...@gmail.com>
Subject how can i add an input parameter to this example
Date Mon, 04 May 2009 19:33:49 GMT
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!

Mime
View raw message