WebLogic Server Support Pattern: CLOB/BLOB Data Type Handling Issues (Doc ID 1332275.1)

Last updated on MARCH 06, 2025

Applies to:

Purpose

Problem Description

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.

Problem Troubleshooting

This pattern provides some common methodologies that can be followed to troubleshoot CLOB/BLOB problems using the Oracle database.

Troubleshooting Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.