Report based on "PL/SQL function body returning SQL query" sort issue
Version information:
- APEX 4.0.2.00.07
- Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
- APEX listener + Oracle fusion middleware 11gr1 (weblogic)
- Mozilla Firefox 5.0
I have created a report based on a dynamic query, generated by a packaged function:
- Type: SQL Query (PL/SQL function body returning SQL query)
- Template: Reports Region
- Region Source: RETURN pck_axirs_mis_report.query_statement_rapport;
- Use generic column names: checked
- Maximum number of generic report columns: 26
- Report Template: 1000. Standard
This report works fine as is: data is retrieved upon execution, changing filters for the query also changes the resultset.
The only problem I'm experiencing with this is that I receive a "no data found" error when I sort on a column in the report. Refreshing the browser after getting the "no data found" error does fetch the data, in the desired order.
Does anyone have an idea what might cause this behaviour?
Kind regards,
Kurt