I'm building a plug-in on apex.oracle.com based on a list of values and am running into a maximum rows issue. I've researched online and in this discussion forum and not found what I'm missing. I'm sure I'm missing something simple, but just can't put my finger on it.
The rendering PL/SQL code contains the following statement :
l_column_value_list := apex_plugin_util.get_data ( p_sql_statement => p_item.lov_definition, p_min_columns => 2, p_max_columns => 2, p_max_rows => 6, p_component_name => p_item.name );
Although I am passing a value to limit the number of rows, the result of the query when running the page is limited to two records. Even when I leave the p_max_rows value out, the result is limited to two records. I've attempted to use both the get_data and the get_data2 procedures in the apex_plugin_util package and both result in the same thing. For testing purposes, I am using the following query :
select ename, empno from emp
I add "order by ename" and see two of the emp records. I add "order by ename desc" and see two different rows from the emp table.
When I run the page in debug mode, I see the following instrumentation :
...Execute Statement: select a.* from (select ename descr, empno cd from emp)awhere ROWNUM <= :p$_max_rows
If if this is the thing controlling the number of rows being displayed, where is that p$_max_rows being set within the plug-in context and how can I control it? If this is not the mechanism controlling the number of rows returned, can someone point me to what I'm missing?
Shane.