Do verify if the types of your IN params are correct. You might wanna verify what each param maps to in the database. Can you pass "0" as the value and see if it runs and the try and pass "foo" and see if you get the same error.
On Tue, Aug 19, 2008 at 1:50 PM, Vinaya Tirikkovalluru < [EMAIL PROTECTED]> wrote: > 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. >
