First to answer your direct question: No there is no limit to the size of a BLOB that you can save to Oracle with LV. I know this because I routinely save BLOBS a lot larger than 2k to an Oracle 10 database. The main difference is that I gave up on the Database Connectivity Toolkit a long time ago because it is way too expensive, it doesn't work very well and it's totally unnecessary. To replace it, do a search of my posts and a while back I posted a library of the drivers that I wrote and use. They are much more efficient than the DCT and are easier to use. In addition because they are essentially a thin layer covering the underlying the ADO interface in Windows, they make it easier to diagnose problems when they do occur. Which brings us back to your problem...
As I understand your post, the BLOBs are trucated to 2000 bytes. Yes? Are there any errors generated? What is the structure of the table in question? Could you post the SQL that created the table? What does your connection string to the database look like?
Mike...
