I've stumbled upon an issue where when too many instances of one of our dynamic actions are on a page I get the following error:
Exception in "final_exception_handler":
Error Stack: ORA-06502: PL/SQL: value or conversion error: character string buffer too small
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_ACTION", line 484
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_ACTION", line 484
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 1139
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 2401
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 3098
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 3308
Backtrace: ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_ACTION", line 484
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_ACTION", line 484
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 1139
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 2401
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 3098
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 3308
ORA-06512: at "APEX_240200.WWV_FLOW", line 3393
As the call stack is inside APEX native packages I don't suspect the issue lies within the plug-in code.
I attached an app export to reproduce the issue.
f136.sql