OSB 11g - Business Service Truncating Return String to 4000 Characters When Using DB Adapter with MS SQL Server
Last updated on MARCH 01, 2017
Applies to:Oracle Service Bus - Version 220.127.116.11.0 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:
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