APEX 5.0.2/Oracle 11.1
One of my Set Value (SQL statement returning 1 row and 1 column) dynamic actions is throwing an error, debug output below.
Has there been any change in this area? Is there some VARCHAR2 4000 (or worse 2000!) limit hiding somewhere?
Thanks
Run NATIVE/PLUGIN= request
...Execute Statement: ....
...Error data:
......message: AJAX call returned server error ORA-06502: PL/SQL: numeric or value error for Set Value.
......is_internal_error: true
......apex_error_code: APEX.AJAX_SERVER_ERROR
......ora_sqlcode: -6502
......ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error
......error_backtrace: ORA-06512: at "APEX_050000.WWV_FLOW_PLUGIN_UTIL", line 1243
ORA-06512: at "APEX_050000.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 208
......component.type: APEX_APPLICATION_PAGE_DA_ACTS
......component.id: 8512006636773486
......component.name: NATIVE_SET_VALUE
Stop APEX Engine detected
Update: Yup, wrapping the SQL in a SUBSTR(val,1,2000) gets past the DA error. I am pretty sure APEX 4.2 used to allow larger values.
Seriously? The 2000 characters limit is still around in 2015?!