OSB 11g - Business Service Truncating Return String to 4000 Characters When Using DB Adapter with MS SQL Server (Doc ID 1559108.1)

Last updated on MARCH 01, 2017

Applies to:

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

Symptoms

There is a Stored Procedure in MS SQL Server that will query multiple tables and construct an XML document to be returned as a string. This Stored Procedure is invoked via a OSB business service with DB Adapter, and the following two scenarios have been seen:

1 - When the Stored Procedure returns nvarchar(max), varchar(max) or text as output, the Business Service truncates the output string to 4000 characters.
2 - When the Stored Procedure returns XML as output, the following error is thrown:



Cause

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