ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Campbell" <rrc...@gmail.com>
Subject Stored procedure return value?
Date Wed, 09 Aug 2006 14:35:06 GMT
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