Why do I have problems writing BLOBs/CLOBs longer than 4k with an Oracle database?

Joe Sam Shirah

JDBC functionality is completely dependent on the functionality of the JDBC driver AND the underlying DBMS engine. At one time there was a 4k restriction on LOBs. It's not clear from the documentation exactly when this restriction was lifted, although it definitely has been by 8i, Release 2(8.1.6). Even so, there are other limitations and restrictions that can cause write problems for LOBs.

The best resource is the source, even though Oracle has an annoying habit of giving examples using proprietary methods, which hinders portability. See: Oracle8i Application Developer's Guide - Large Objects (LOBs), especially section 6 Frequently Asked Questions, as well as the Oracle8i JDBC Developer's Guide and Reference. Note that Oracle Technical Network registration is required to access these documents.