ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bala r" <bala...@gmail.com>
Subject Uregent help needed StoredProcedure call with paramater Map
Date Tue, 19 Aug 2008 20:44:26 GMT
I  am using ParameterMap to map StoredProcedure IN parameters.
If all parameter have value then storedproeceure is executed fine.
But if one of the parameter is empty then getting exception
"PL/SQL: numeric or value error: character to number conversion error"
getting error.
here are teh sqlmap details.
<parameterMap id="product_map" class="java.util.HashMap" >
       <parameter         property="item_type_id"
jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
        <parameter         property="item_id"
jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
        <parameter         property="web_display_name"
jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
        <parameter         property="url"
jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
        <parameter         property="uri"
jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
</parameter>
<procedure id="product" parameterMap="product_map">
        {call product.load (?,?,?,?,?)}
    </procedure>

Thanks in Advance.

Thanks
Bala.

Mime
View raw message