ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Uregent help needed StoredProcedure call with paramater Map
Date Tue, 19 Aug 2008 20:47:10 GMT
VARCHAR2 is not a valid JDBC type - try VARCHAR instead.

Jeff Butler



On Tue, Aug 19, 2008 at 3:44 PM, bala r <balar4u@gmail.com> 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.
>

Mime
View raw message