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 <[EMAIL PROTECTED]> wrote:
> 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.
>>
>
>
