WebLogic Server Support Pattern: CLOB/BLOB Data Type Handling Issues
(Doc ID 1332275.1)
Last updated on SEPTEMBER 29, 2020
Oracle WebLogic Server - Version 10.0 and later Information in this document applies to any platform.
***Checked for relevance on 10-Aug-2015***
WebLogic Server versions that support the JDBC 3.0/4.0 specifications support the use of BLOB (Binary Large Object) and CLOB (Character Large Object) data types. These data types were made available with the release of Oracle DB version 8 and above. Sybase and MS SQL Server databases do not natively support these data types; however, certain Sybase and SQL Server drivers (for example Datadirect) provide both read and write support for BLOB/CLOB data types for Sybase and MS SQL Server. Users face many problems when they use incorrect programming techniques with the above data types. Also, changes in the database driver APIs when migrating from one WebLogic Server version to another leads to incompatible code. A number of cases related to these issues have been raised.
This pattern provides some common methodologies that can be followed to troubleshoot CLOB/BLOB problems using the Oracle database.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!