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
Hello Julienc,
we have a similar use case at the moment, I'm curious as to what solution you ended up using.
Thank you.
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.
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.