Java Development Tools

Hi,

I am using Jdeveloper 11.1.1.7.0 with Java  1.7.0_71.

consider a table named employee with a column "level".

Column 'level' can have one,two,three,four and five as values.

I need to dynamically set the value for the level in different situations ex: select * from employee where level in ('one','two') or select * from employee where level in ('three','two')

I have created a View object with the query as ,

select employeeId,employeeName,Level from employee where level = :BindLevel

How to set the :Bindlevel expression ?

I have tried ,

  <Variable

    Name="BindLevel"

    Kind="where"

    Type="java.lang.String">

    <TransientExpression><![CDATA[return " IN ('one','two')";]]></TransientExpression>

  </Variable>

This is not working.

Kindly provide the solution to use IN clause in bind parameter value expression.

Thanks.