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.

Reply via email to