Search code examples
ibatis

How to map a stored package function in iBatis?

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 ?

Solution

  • 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.