Hello, Apex experts,
I am using apex.oracle.com online version 22.1
I have a page item P1_JSON that stores a JSON content, when submitting the page, it branches to the next page, the value of P2_JSON is set by the value &P1_JSON.
I got an error:
Technical Info (only visible for developers)
is_internal_error: true
apex_error_code: APEX.UNHANDLED_ERROR
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APEX_220100.WWV_FLOW_UTILITIES", line 8203 ORA-06512: at "APEX_220100.WWV_FLOW_PAGE", line 1668 ORA-06512: at "APEX_220100.WWV_FLOW_PAGE", line 52031048 ORA-06512: at "APEX_220100.WWV_FLOW_PAGE", line 3310
component.type: APEX_APPLICATION_PAGES
component.id: 110756000000156
component.name: Order Summary
error_backtrace:
ORA-06512: at "APEX_220100.WWV_FLOW_UTILITIES", line 8203
ORA-06512: at "APEX_220100.WWV_FLOW_PAGE", line 1668
ORA-06512: at "APEX_220100.WWV_FLOW_PAGE", line 52031048
ORA-06512: at "APEX_220100.WWV_FLOW_PAGE", line 3310
ORA-06512: at "APEX_220100.WWV_FLOW", line 3308
I copied the JSON content to Notepad++, there are 1807 characters (much less than 4000), If I set the P2_JSON default static value with this JSON content, everything works. But Apex couldn't set P2_JSON with &P1_JSON. when the branch (page redirect) happens.
Is there any limitation on how much content you can store in an item and carry over to an item in the next page? If there is, any workaround?
The funny thing is I have a demo app that works with exactly the same JSON content, and it simply works, there might be some settings on the application level? Just guessing...
Please advise, thank you very much!
Larry