My app is built on an Oracle Database.
Would it be possible to overcome the 4000 byte of Text limitation we have for Synchronized Records fields?
I know the VARCHAR2(4000) limitation is considered to be a standard column type by Oracle, then choosing the EXTENDED for param. max_string_size in the DB would make it an "extended data type", as CLOB is. But since CLOB is forbidden to become a Snyc. RT field, would my large VARCHAR2 columns be also forbidden?
Asking for people who tried it. If no one did, I will ask the DBA, but could be easier to ask here ;)
Discussion posts and replies are publicly visible
In that case, you cannot sync that record.
Or, you sync it, but need to do an extra query to fetch these long text fields when displaying the data. Not convenient and troublesome on the long run, but might be worth considering.