My Oracle Support Banner

Oracle.sql.BLOB@7bf33f32 In Output When Fetching BLOB Data Using DB Adapter (Doc ID 3010301.1)

Last updated on MARCH 18, 2024

Applies to:

Oracle SOA Suite - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When using Oracle Database Adapter Pure SQL mode to retrieve a BLOB colum from the database, the content of the retrieved column is oracle.sql.BLOB@7bf33f32 instead of the real data even when the Database Adapter Wizard generated XSD schema defines the column as xs:base64Binary where namespace xs is defined as xmlns:xs="http://www.w3.org/2001/XMLSchema"
BLOB type should always be mapped to xs:base64Binary according to Oracle JCA Database Adapter document.

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!

In this Document
Symptoms
Cause
Solution
References


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