Problem msssql function returning XML larger then 4000 characters

[nico_vandevelde]

Hi all,

I have a function in microsoft sqlserver where outcom is returned as XML

Already tried some variants like converting this to String (XML is missing part >4000 chars) in the SQLserver function

XML returning from function cannot be loaded into a document type

Return into an object or byte array gives "Implicit conversion from data type xml to varbinary is not allowed. Use the CONVERT function to run this query."

Not sure wheter this error is caused by JDBC or SQLserver

Anyone already had same issue?

thanks,

Nico