SQL server stored procedure execution link server

The output parameters of the stored procedure in XML

 
DECLARE @ bz_re VARCHAR (1), @ sm_re VARCHAR (500), @ xml_re XML 
The EXEC EDI. Wcfdatatran. Dbo. P_edi_shjl_cshis @ DWDM='52 - T', - varchar (50) 
@ bz=@ bz_re OUTPUT - varchar (1) 
@ sm=@ sm_re OUTPUT - varchar (500) 
@=@ xml_re XML OUTPUT -- XML 
SELECT @ bz_re @ sm_re, @ xml_re 

Tip:
Message 9512, level 16, state 1, line 2
Xml data type cannot serve as the parameters of the remote invocation,


How to deal with, please?

CodePudding user response:

Are there any people?

CodePudding user response:

XML is also a string, if you can modify the stored procedure, can change to return to nvarchar (Max) type, come over with a cast or convert into XML type

CodePudding user response:

Hello World reference 2 floor, response:

XML is also a string, if you can modify the stored procedure, can change to return to nvarchar (Max) type, come over with a cast or convert into XML type

Message 7396, level 16, state 1, line 2
Remote query or the return value of the output parameters do not support a varchar (Max), nvarchar (Max), varbinary (Max) and large CLR type data types,

CodePudding user response:

seems to support a VARCHAR (8000) or NARCHAR (4000), don't know your XML how long is the longest?