Has anyone ever changed the Max String Size parameter in Oracle to Extended? I know the standard VARCHAR2 limitation in Oracle is 4000 bytes. I have had a few customers ask for Custom Fields and standard fields to be larger such as the external notes on the service quotation and Long Description for PM Work Orders. Apparently in Oracle, if you change this parameter to extended it gives you a new max size of 32767 bytes. I was curious if anyone in the community has done this successfully? If so, was there any special items you might want to mention? Did this also work when adding new custom fields after changing the parameter?
https://dbaclass.com/article/max_string_size-parameter-oracle-12c/