My Oracle Support Banner

Reading a 3 GB BLOB with JDBC 11.2.0.1 Fails With "ORA-22925: operation would exceed maximum size allowed for a LOB value" (Doc ID 1101087.1)

Last updated on MARCH 13, 2019

Applies to:

JDBC - Version 11.2.0.1.0 to 11.2.0.2.0 [Release 11.2]
Oracle Database - Standard Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Add ***Checked for relevance on 28-Feb-2013***



Symptoms

A java application reads BLOBs from a database and writes them to a file using the code:


When using JDBC 11.2.0.1 to read a 4 GB or larger BLOB from a 10.2.0.3 database, the ORA-22925 error also occurs.

However, when using JDBC 11.2.0.1 to read a 4 GB or larger BLOB from an 11.1.0.6 database, the output is truncated without an error. See <Note 1101163.1> Silent (No Error) Truncation Reading a 4 GB or Larger BLOB with JDBC 11.2.0.1 for details.

When using JDBC 11.1.0.7 to read the same 3GB, 4GB and larger BLOBs, the ORA-22925 does not occur. Nor does truncation occur.

Changes

The ORA-22925 occurred after upgrading JDBC 11.1.0.7 to JDBC 11.2.0.1.

Cause

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

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


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