ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sundar Sankar" <fatboys...@gmail.com>
Subject Re: Uregent help needed StoredProcedure call with paramater Map
Date Tue, 19 Aug 2008 20:56:20 GMT
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 <
vinaya.tirikkovalluru@converge.com> 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: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