http://adfbugs.blogspot.com/2009/07/performance-tuning-lovs-and-range.html
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(SQLStateMapping.java:70)
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 11.1.1.4 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:
http://adfbugs.googlecode.com/files/LovRangePagingBug.zip
(Fixed in 11.1.1.4)
ReplyDeleteHi,
ReplyDeletePresently 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 (11.1.2.3.0).
Thanks
Narsing