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)
ReplyDelete