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>

Reply via email to