I am trying to execute a SP in webMethods and one of the OUT parameter(of type varchar(max)) retrieves XML. But the XML is truncated when the result comes in webMethods. While i get a full XML when i run the SP from Management Studio. The size of the XML is 4KB, which should be fine, then why is my result getting chopped? in webMethods SP, i have defined the Param JDBC type as VARCHAR and i even tried LONGVARCHAR, NVARCHAR,LONGNVARCHAR, but nothing seems to work. Any clues? I am missing any designer patches?
I am using 9.9 Designer, IS version is 9.6; Core Fix 10,JDBC 6.5 Fix 48