VARCHAR2 is not a valid JDBC type - try VARCHAR instead.
Jeff Butler
On Tue, Aug 19, 2008 at 3:44 PM, bala r <[EMAIL PROTECTED]> wrote:
> 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.
>
