I'm using apex 5.0.3, universal theme and 11g DB
I have a classic report with this SQL
SELECT APEX_ITEM.checkbox(19,c001,'onclick="f_ClickCheckBox(this)" id="fAV01'||seq_id||'"','Y') bselect,
APEX_ITEM.popup_from_query(20,c004,kvs1050.lov_sql_get('AV','segment_code',c003),10,
p_attributes=>'onchange="f_ChangeList(this,''fAV04'||seq_id||''')"') code_from,
FROM apex_collections
WHERE collection_name = 'CP'
I created on demand page process where I simply raise an exception
raise_application_error(-20001,'Error test');
I debug this pl/sql code and I verified that this is being executed (I have custom pl/sql code to create a trace file for all the messages).
My issue now is on the page after changing the value it does not give any errors.
My goal is to create classic report based on collection since I need to have 10 of these in 1 page so tabular form will not work and have the ability to validate current value, update collection and update current value to something else (ex. 1 will be 001) for any columns. in the report
I think DA will not work for report columns?