Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

a_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Ehsan FathiNov 6 2024

Hello.

Once, I extended the datatype on Oracle Database 19 and increased the value from 4000 to 32000. However, Oracle APEX pages are not rendering this value.
Is this behavior normal?
Also, my Oracle APEX installation was set up when VARCHAR was limited to 4000.
Do I need to reinstall APEX after extending?

ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APEX_220200.WWV_FLOW_PAGE", line 1932 ORA-06512: at "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1655 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at line 4 ORA-06512: at line 13 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 267 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 312 ORA-06512: at "APEX_220200.WWV_FLOW_REGION_NATIVE", line 318 ORA-06512: at "APEX_220200.WWV_FLOW_REGION_NATIVE", line 2327 ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 2766 ORA-06512: at "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1023 ORA-06512: at "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1584 ORA-06512: at "APEX_220200.WWV_FLOW_PAGE", line 1880
component.type: APEX_APPLICATION_PAGE_REGIONS
component.id: 73961947129344823
component.name: POST_CONTAINER
This post has been answered by Yassine Wahbi-Oracle on Nov 8 2024
Jump to Answer

Comments

Post Details

Added on Nov 6 2024
1 comment
196 views