How to map a stored package function in iBatis?

Question

I am presently using

<parameterMap class="map" id="param1">
    <parameter property="result" jdbcType="BOOLEAN" javaType="boolean" mode="OUT"/>
    <parameter property="arg1" jdbcType="VARCHAR" mode="IN"/>
    <parameter property="resultCode" jdbcType="INTEGER" javaType="int" mode="OUT"/>
</parameterMap>

<procedure id="contAvail" parameterMap="param1">
    <![CDATA[
        { ? = call pkg.func(?,?)}
    ]]>
</procedure>

what is missing ?

Answer 1

You have two parameters in your CALL but a parameterMap with three parameters. You have one result but no resultMap.

Not sure if the CDATA hurts anything, but it shouldn't be needed.

See the online help for details. Also check out this and this.

Answer 2

It turns out there is nothing wrong with the code above. It works if we change the return data type from boolean to anything else. It seems boolean is not supported properly.

Also as Jim rightfully suggested, CDATA is not imp. It works with or without it.