ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sundar Sankar <fatboys...@gmail.com>
Subject Re: how can i add an input parameter to this example
Date Mon, 04 May 2009 19:56:57 GMT
As far as I know, U cant do multiple cursor returns with Ibatis. I remember
having tried it way before and was unsuccessful. Am not sure if the later
versions have them.

-Sundar

On Mon, May 4, 2009 at 12:33 PM, Bhaarat Sharma <bhaarat.s@gmail.com> wrote:

> 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