Thanks for the reply, I will try your change tomorrow when I get to the
office.
How ever I am kind of confused here because I have seen the syntax that you
are using before on the mailing list.
Nevertheless I thought that '(?)' after the SP is for 'IN' parameters and
not for 'OUT'.
In standard jdbc '? = function_name(?) ' the '?=' describes the OUT param
whereas (?) after the function is for IN params.
Thanks,
Mark
On 5/2/07, Yee, Richard K CTR DMDC <[EMAIL PROTECTED]> wrote:
Try this:
<parameterMap id="mymap" class="java.util.Map">
<parameter property="value" mode="OUT" /> </parameterMap>
<procedure id="getSequence" parameterMap="mymap">
{ call f_gettsid(?) }
</procedure>
-----Original Message-----
From: Mark Bleichert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007 11:54 AM
To: [email protected]
Subject: How do you call a stored procedure with a single OUT parameter
I was wondering if you could give me an example of how to call a stored
procedure in ibatis sqlmaps that has no IN parameters and a single OUT
parameter of type varchar.
I went through all the mail-archive threads but nothing seemed to work.
-------------------------------------------------- calling code
----------------------------------------------
Map map = new HashMap();
map.put("value", "0");
map = (HashMap)queryForObject("getSequence", map);
-------------------------------------------------- xml mapping
----------------------------------------------
<parameterMap id="mymap" class="java.util.Map">
<parameter property="value" mode="OUT" /> </parameterMap>
<procedure id="getSequence" parameterMap="mymap">
{ ? = call f_gettsid }
</procedure>
Any suggestion to what I am doing wrong ?
