ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bala r" <bala...@gmail.com>
Subject Re: Uregent help needed StoredProcedure call with paramater Map
Date Tue, 19 Aug 2008 20:51:08 GMT
Hi,

I changed to VARCHAR still getting the same error.
Procedure works fine in SQLPlus. Also procedure fine thru Ibatis if all
parameters have value. Only when one of the parameter is empty or null then
i am getting the error.

Thanks
Bala.


On Tue, Aug 19, 2008 at 4:47 PM, Jeff Butler <jeffgbutler@gmail.com> wrote:

> 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