ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bala R K" <kbas...@gmail.com>
Subject Passing Values to IN Operator in Oracle Stored Procedure
Date Mon, 19 Jun 2006 08:00:42 GMT
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