Hi,

I am invoking a oracle FUNCTION returning Oracle OBJECT TYPE. I am able to retrieve a STRUCT from that. Can anyone tell me how do I map the fields in struct to a Java bean in sql map configuration.

My SQLMap configuration is as follows -

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "sql-map-2.dtd">
<sqlMap>
<parameterMap id="GetClientInfo-param-map" class="java.util.Map">
    <parameter property="result" jdbcType="STRUCT" typeName="XT_CLIENTINFOVALUEOBJECT" mode="OUT" typeHandler="com.ibatis.sqlmap.engine.type.ObjectTypeHandler"/>

    <parameter property="clientId" jdbcType="DECIMAL" javaType="java.math.BigDecimal" mode="IN" />
    <parameter property="serviceName" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
    <parameter property="isNewService" jdbcType="CHAR" javaType="java.lang.String" mode="IN" />
</parameterMap>
<procedure id="GetClientInfo" parameterMap="GetClientInfo-param-map">  
        {? = call PKG_CLIENTINFO.getClientInfo(?, ?, ?) }
</procedure>
</sqlMap>

Thanks,
Ruchi