Monday, June 14, 2010

Range Paging in LOVs bug #9467477

Using Range Paging in LOVs is fixed in new jdeveloper

Yet it still has bugs, when you use LOV criteria or on dependent LOV sometimes it shows error:

java.sql.SQLException: Missing IN or OUT parameter at index:: 1 at oracle.jdbc.driver.SQLStateMapping.newSQLException(

I have posted an SR for this and bug was logged #9467477 SQLEXCEPTION: MISSING IN OR OUT PARAMETER AT INDEX, IN LOV WITH RANGE PAGING, that it is also fixed for next jdeveloper release. Thanks Didier.

I decided to post it also here since this bug is not public visible in Support (not even for me that i posted the SR.

Steps to reproduce in test case are:
1. Open Departments LOV
2. Scroll down to LOV until fethcing data message apears
3. Type in criteria for departmentId value i.e.'1' and without pressing Search select a row in LOV.SQL
Error message apears:

Test Case:


  1. Hi,

    Presently I am facing the same problem. But not for LOV. I used Range Paging as access mode to tune the VO, Range Size is 100. I created a search region (af:query with table ) with that VO and the table has a selection listener. Upon selecting a row there will be a graph rendered. The selection is working fine for rows upto 100 once a scroll down action is performed upon selecting a row the error pops up saying. "Missing in or Out parameter" .

    So, Is there any workaround for this.(Other than not using Range Paging :) ).

    And this error is happening even in the latest build of jdev (