>Regarding the configuration and defaults in 12.2 > , with Oracle support I went over linked server /provider parameters (Dynamic Parameters, Allow InProcess, Collation Compatible), all were set as documented...

Just a quick note....

If you draw in the whole table normally...

sample:

FROM OPENQUERY([HEPRD-COURSES],

'SELECT * FROM PS_ZVSR_CLASS_NOTE') [zClassNote]

try casting the offending field

sample2:

FROM OPENQUERY([HEPRD-COURSES],

'SELECT CLASS_NOTES_SEQ, CAST(SUBSTR(DESCRLONG,1,4000) AS VARCHAR2(4000)) as DESCRLONG, CRSE_ID, CRSE_OFFER_NBR, STRM,...

Thank you! I will have a look!