ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vinaya Tirikkovalluru" <vinaya.tirikkovall...@converge.com>
Subject RE: Uregent help needed StoredProcedure call with paramater Map
Date Tue, 19 Aug 2008 20:50:03 GMT
Yes,

That's what would happen, If I understand correct

May be you need to check the procedure, if its throwing an exception if
you execute with out passing all the values

 

 

 

________________________________

From: bala r [mailto:balar4u@gmail.com] 
Sent: Tuesday, August 19, 2008 4:44 PM
To: user-java@ibatis.apache.org
Subject: Uregent help needed StoredProcedure call with paramater Map

 

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.



This electronic message is intended only for the use of the individual(s) or entity(ies) named
above and may contain information which is privileged and/or confidential.  If you are not
the intended recipient, be aware that any disclosure, copying, distribution, dissemination
or use of the contents of this message is prohibited.  If you received this message in error,
please notify the sender immediately.

Mime
View raw message