ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mkhitaryan, Aram" <Aram.Mkhitar...@lycos-europe.com>
Subject RE: Stored procedure return value?
Date Thu, 10 Aug 2006 04:47:12 GMT
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:rrc7cz@gmail.com] 
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>



Mime
View raw message