ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chema <demablo...@gmail.com>
Subject Re: how can i add an input parameter to this example
Date Mon, 04 May 2009 20:10:41 GMT
Could you paste parameterMap definition ?


2009/5/4 Bhaarat Sharma <bhaarat.s@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!
>

Mime
View raw message