SOA DB Adapter truncating the data when retrieving an image from an MS SQL Server Database

(Doc ID 2111409.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Service Bus - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.1.7.0 version, OSB Core Functionality

When invoking an MS SQL Server stored procedure that returns an image, the SOA DB Adapter is truncating the data when retrieving images.

The SOA DB adapter fetches only the first 8000 bytes of the image.



Solution

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 hundreds of Community platforms