do the direct oracle access components support the oracle 12c extended strings? Varchar2 longer than 4000; One of our customers changed max_string_size to EXTENDED and almost immediately runs into access violations.
When extended strings are enabled you can run into problems with query fields that are based on character operations or character function results, even if all table character columns are smaller than 4000 bytes.