My Oracle Support Banner

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 13, 2019

Applies to:

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


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:


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.