ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Debasish Dutta Roy" <debasish.dutta...@gmail.com>
Subject Re: Passing Values to IN Operator in Oracle Stored Procedure
Date Mon, 19 Jun 2006 18:02:42 GMT
Hi you have to use dynamic tag. Here is an example

        <dynamic prepend="WHERE">
            <iterate open="COUNTRY_ID IN(" close=")" conjunction=",">
                #[]#
            </iterate>
        </dynamic>

>From java code all your country ids are in a java.util.List object.


On 6/19/06, Bala R K <kbase04@gmail.com> wrote:
>
> Hi,
> I am using Java, Oracle 9i and iBatis 2.1.7 in my application.
> I like to know how to pass values to a IN Operator for a Stored Procedure.
>
> The query will be some what simalar like this:
>
> select COUNTRY_NAME,REGION from countries where COUNTRY_ID IN('AR','IN');
>
> The values for IN operator (String within single quote and comma
> separated)i.e. 'AR','IN' need to be passed from the client.
>
> Thanks,
> Bala
>

Mime
View raw message