consider using a tmp table if you encounter this error (a) insert into tmp
table, b) join your select with the
tmp table). Most of the time ist should be faster than doing than combining OR
and IN statements.
cheers
Kai
--- Original Nachricht ---
Absender: BruceKKK
Datum: 19.06.2009 05:34
> i met ora-01795 error, so i need separate list to several size limited lists,
> I am trying use nested iterators to iterate over a List of List using
> following code:
>
> <select id="getList" parameterClass="map" resultClass="com.ResultObject">
>
> select ***** from ****** where
> <isNotEmpty property="outLists" >
> <iterate property="outLists" open="(" close=")" conjunction="OR">
> data in
> <iterate property="outLists[]" open="(" close=")" conjunction=",">
> #outLists[].[]#
> </iterate>
> </iterate>
> </isNotEmpty>
> </select>
>
> but i got exception:
> com.ibatis.common.beans.ProbeException: Error getting ordinal list from
> JavaBean. Cause java.lang.NumberFormatException: For input string: ""
>
> how to make it run?
>
> by the way: the version of ibatis i used is 2.1.7
