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
Not possible with synced records. You can set the underlying field to whatever you want but Appian will only synchronize 4000 characters The rest will be truncated.
Only workaround for fields longer than 4000 is to use the Data Store with CDTs approach.