Unable to Use Range Paging Feature in ADF BC LOV (Doc ID 1060111.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version 11.1.1.0.0 to 11.1.2.0.0
Information in this document applies to any platform.

Symptoms

You are trying to use the Range Paging feature in a List of Values, but it fails with the following error:

Exception in thread "AWT-EventQueue-0" oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT /*+ FIRST_ROWS */ IQ.*, ROWNUM AS Z_R_N FROM (SELECT Departments.DEPARTMENT_ID, Departments.DEPARTMENT_NAME, Departments.MANAGER_ID, Departments.LOCATION_ID FROM DEPARTMENTS Departments ORDER BY Departments.DEPARTMENT_ID) IQ WHERE ROWNUM < :Bind_RangePage_High) WHERE Z_R_N > :Bind_RangePage_Low
at oracle.jbo.server.OracleSQLBuilderImpl.bindRangePagingParams(OracleSQLBuilderImpl.java:1684)
...
Caused by: java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Bind_RangePage_High
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
...
## Detail 0 ##
java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Bind_RangePage_High
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
...


and:

oracle.jbo.expr.JIEvalException: JBO-25077: Name DepartmentId not found in the given object: null.
at oracle.jbo.common.JboBeanUtils.getPropertyInMapOrBean(JboBeanUtils.java:246)
at oracle.jbo.RowValueSupplier.getExprVarVal(RowValueSupplier.java:110)
at oracle.jbo.RowValueSupplier.getExprVarVal(RowValueSupplier.java:71)
at oracle.jbo.RowValueSupplier.getExprVarVal(RowValueSupplier.java:93)
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms