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