Skip to Main Content



For appeals, questions and feedback, please email

Aligning APEX with the updated database parameter max_string_size set to EXTENDED

Alex VMar 23 2024 — edited Mar 23 2024


When APEX was initially installed, the max_string_size database parameter was set to STANDARD. Later, this parameter was changed to EXTENDED. However, it appears that all resources related to Oracle APEX are still constrained by the maximum VARCHAR2 limit of 4000 bytes.

Is there a way to enable APEX to utilize the full VARCHAR2 size of 32000 bytes, as permitted by the max_string_size EXTENDED setting, without having to completely reinstall APEX and all its applications? Would an upgrade to a newer version of APEX resolve this issue?

Additionally, I've come across references to the SYS.validate_apex function, which might be of assistance. Unfortunately, I haven't been able to find any documentation on it.

I'm currently using Oracle Database version 19c and APEX version 23.1.

Thank you in advance for any assistance you can provide.

This post has been answered by Carsten Czarski-Oracle on Mar 25 2024
Jump to Answer
Post Details
Added on Mar 23 2024