APEX Gurus
I have a report which is generated dynamically, the source being a
PL/SQL function body returning SQL query. The on-screen output is generated using mod plsql, i.e. an html table.
If I run the report with parameters which return more than 100 columns, all are displayed on screen
However, if I click on the (standard functionality) 'export to csv' link at the bottom of the report, not all of the columns are exported.
If I navigate to the report definition page, firstly a pop-up error appears: "A Runtime Error has occurred. Do you wish to debug? Line 272 Error: ';' Expected". If I click 'no' then the report definition appears. There are 100 columns listed 'Col01', 'Col02', 'Col03' ... 'Col100'.
I can't edit anything on the page without getting an error when I apply changes:-
ORA-20505: Error in DML: p_rowid=107779820132310508, p_alt_rowid=ID, p_rowid2=79506526374684203, p_alt_rowid2=SECURITY_GROUP_ID. ORA-20503: Current version of data in database has changed since user initiated update process. current checksum = "E8F1BCECF94FAD8DF3ECC3E74BCC4D50" application checksum = "0"
ORA-20505: Error in DML: p_rowid=107779820132310508, p_alt_rowid=ID, p_rowid2=79506526374684203, p_alt_rowid2=SECURITY_GROUP_ID. ORA-20503: Current version of data in database has changed since user initiated update process. current checksum = "E8F1BCECF94FAD8DF3ECC3E74BCC4D50" application checksum = "0"
The only option is a hyperlink to go back: 'Return to application'. No changes are saved.
I am wondering if I am hitting 2 problems:-
1. APEX can't handle more than 100 columns
2. APEX can't handle editing of the page once it has been created?
Does anyone have any good ideas/seen this before?
Could it be related to this
671008 ?
Is this a bug or an undocumented feature?
All help appreciated.
Ian