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:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 4:44 PM To: [email protected] 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.
