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 and later
Information in this document applies to any platform.


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=""
BLOB type should always be mapped to xs:base64Binary according to Oracle JCA Database Adapter document.


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

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