Hi,
What means here “{? = call”?
I did procedure calls with following
syntax: {CALL PROC_NAME(?,?,…)}.
Try to use this way.
Best,
Aram
From: Robert Campbell
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 09, 2006
7:35 PM
To: iBatis
Subject: Stored procedure return
value?
Here is what I'm trying
to do:
<parameterMap id="addParam"
class="flubSponsor">
<parameter
property="output1" jdbcType="ORACLECURSOR"
mode="OUT" />
<parameter
property="flubId" jdbcType="NUMBER"
javaType="java.lang.Integer" mode="IN"/>
<parameter
property="flubName" jdbcType="VARCHAR" javaType="
java.lang.String" mode="IN" />
<parameter property="id"
jdbcType="NUMBER" javaType="java.lang.Integer"
mode="IN"/>
<parameter
property="sponsorId" jdbcType="NUMBER" javaType="
java.lang.Integer" mode="IN"/>
<parameter
property="sponsorName" jdbcType="VARCHAR"
javaType="java.lang.String" mode="IN" />
</parameterMap>
<resultMap id="flubSponsorResult"
class="awardSponsor">
<result property="flubId"
column="FLUB_ID"/>
<result property="flubName"
column="FLUB_NAME"/>
<result property="id"
column="FLUB_SPONSOR_ID" />
<result property="sponsorId"
column="SPONSOR_ID" />
<result
property="sponsorName" column="SPONSOR_NAME"/>
</resultMap>
<procedure id="submitAwardSponsor"
parameterMap="addParam"
resultMap="flubSponsorResult">
{? = call
FLUB_PROTO.flub_sponsor_tst.submit_flub_sponsor (?, ?, ?, ?, ?)}
</procedure>
|
- RE: Stored procedure return value? Mkhitaryan, Aram
-