Hi,
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.