Hi Guys ,

We are facing strange beviour / issues with bindVaribale queries.

Jdev: 12.2.1.0

We have a query based View Obeject :

SELECT  coalesce(wd.utilize_all_res_year('Y','single',:bindOrgId1),0) per,coalesce(wd.utilize_all_res_year('N','single',:bindOrgId2),0) contractor from dual

and have two bind Variables : bindOrgId1 and bindOrgId2

Requirement :

We have a two pages. We need to show per and contract values in second page based on first page user selected Org id's  , so we are executing the RVO with passing bind variables as follows :

         vo.setNamedWhereClauseParam("bindOrgId1 ",100);     

         vo.setNamedWhereClauseParam("bindOrgId2 ",1020);      

          vo.executeQuery();

But we are getting below error while run executeQuery statement .

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT  coalesce(wd.utilize_all_res_year('Y','single',:bindOrgId1),0) per,coalesce(wd.utilize_all_res_year('N','single',:bindOrgId2),0) contractor from dual

Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

Its not only this view Object , we created 3 RVO's and doing same approach (setNamedWhereClause---) getting same issues.

But we are not getting these issues in separate application , Mean , we did same requirement in separate application but we are not getting this errors.

We are getting only in my current application .

Can anyone suggest on this. Why its coming here only not any other application .

Any issues with AM .

All Three View Objects are configures in single Application Module.

We are not getting these issues  from some other places code (similar code was used in some other places also.)