My Oracle Support Banner

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

Last updated on OCTOBER 18, 2018

Applies to:

Oracle WebLogic Server - Version 10.0 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Aug-2015***

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Problem Description
 Problem Troubleshooting
Troubleshooting Steps
 Why Does the Problem Occur?
 Recommended Programming Techniques
 WLS 10.3.6 and higher
 WLS 10.3
 How to Insert/Update BLOB Data types
 How to Read BLOB Data Types
 How to Insert/Update CLOB Data Types
 Initializing a CLOB Field
 How to Read Clob Data Types
 WLS 9.2 and WLS 8.1:
 Migrating Applications Due To WebLogic Server Upgrade
 Database Driver
 Known WebLogic Server Issues
References

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