Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of bhaarat.s@gmail.com
 designates 74.125.44.158 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=S3kjPTmZZAwTFnF19M944tUuykEjtxGiispoZYqmvtBMu8iFXQ5h0xwdWB66ArIu3g
         gkSlGrXcv0FtifcQGIBKVhlZsmhS8YyuxUlv9vIOVtBiZKRMLA/DIAFnMuyUxmWf9LlZ
         jEaZnfxgeMNm02TYmJ4yQ8FwzPTii7KrqlrC8=
MIME-Version: 1.0
Date: Mon, 4 May 2009 15:33:49 -0400
Message-ID: <491bd2b50905041233xa67739jf6342f5ba9067d0e@mail.gmail.com>
Subject: how can i add an input parameter to this example
From: Bhaarat Sharma <bhaarat.s@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=001e680f17a8d6c85804691b3d13

--001e680f17a8d6c85804691b3d13
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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!

--001e680f17a8d6c85804691b3d13
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 parame=
ter.<div><br></div><div>I was looking at the following example on the wiki.=
=A0</div>
<div><br></div><div><a href=3D"http://opensource.atlassian.com/confluence/o=
ss/pages/viewpage.action?pageId=3D5653">http://opensource.atlassian.com/con=
fluence/oss/pages/viewpage.action?pageId=3D5653</a><br></div><div><br></div=
><div>
I have two questions:</div><div><br></div><div>=A0- How can I mold this exa=
mple so that if SP is expecting 1 input parameter then the code should work=
. =A0</div><div>=A0I did the following:</div><div>=A0=A0</div><div>changed=
=A0<span class=3D"Apple-style-span" style=3D"font-family: -webkit-monospace=
; font-size: 11px; line-height: 13px; white-space: pre; ">{ ? =3D call refs=
_pck.get_refs } </span>TO=A0<span class=3D"Apple-style-span" style=3D"font-=
family: -webkit-monospace; font-size: 11px; line-height: 13px; white-space:=
 pre; ">{ ? =3D call refs_pck.get_refs (?)}</span></div>
<div><span class=3D"Apple-style-span" style=3D"font-family: -webkit-monospa=
ce; font-size: 11px; line-height: 13px; white-space: pre;"><br></span></div=
><div>The above does not seem to work</div><div>=A0</div><div>I get the fol=
lowing error:=A0</div>
<div><br></div><div>Caused by: java.sql.SQLException: ORA-06550: line 1, co=
lumn 13:
PLS-00306: wrong number or types of arguments in call to &#39;GET_REFS&#39;
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored<br></div><div><br></div><div>- After the above wo=
rks...how can i change it so that it can be used when stored procs return m=
ultiple resultsets. =A0Because &#39;? =3D XXX&#39; means it is taking care =
of just one result set.=A0</div>
<div><br></div><div>Thanks!</div><div><br></div>

--001e680f17a8d6c85804691b3d13--