Sunday, November 18, 2012

Setting the bind parameter to LOV in OAF

How to set the bind parameter to LOV in OAF

Recently i have been facing issues while binding parameters in LOV VO.

There is a small glitch while setting bind parameters in LOV

Consider the below one if you need to a set a bind parameter :

Never mention bind parameter and value, just make the whereClause and place it.

Normal way of bind and assigning values wont work.

Following is the way you need to use for LOV VO


   public void initDeptLOVVO()
    {
    Number dno= new Number(10);
    String whereClause = "deptNo in ("+dno+")" ;
     System.out.println("executed LOV VO ");
     clearCache();
     setWhereClause( whereClause );
     executeQuery();
     System.out.println("Dept Lov QUery-->"+getQuery() ) ; 
    }

No comments: