BLOBs from Oracle truncated to 16 mb

[sdprice]

Hey all, I'm having this BLOB truncation issue from both both OCI and ODBC connectors and using Standard and Dynamic input tools. Alteryx will only get the first 16777216 (2^24) bytes of each BLOB. There are no errors or warnings in the output when this happens, it just assumes it to have been a successful.

I've looked through multiple settings except the Alteryx System Settings (IT locked us out of there) and found nothing obvious that could help with this issue. I've also been able to download the file successfully using JDBC in another software, so I assume it's not a limitation at the database end. 

Any suggestions?

[BrandonB]

Have you taken a look at this link yet? https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Buffer-too-small-for-CLOB-to-CHAR-Orac...

I wonder if you can break it into separate pieces to accommodate the length