How to pass xml type parameter to stored procedure

Anonymous — Mon, 28 Apr 2014 14:36:06 GMT

Hi,

I am trying to call a stored procudere in tMSSqlSP.
stored procedure is as : EXEC . '<?xml version="1.0" encoding="UTF-8"?><customer><PROVIDER customer="C3VD0PIOGI"/></customer>'

This stored procedure take one argument it's type is xml.
But in our talend has document type. when i am passing document type argument its giving error :
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The method Document2Document(Document) is undefined for the type TypeConvert
The method setDocument(int, Document) is undefined for the type CallableStatement
Please help me any one,
Thanks in Advance,

Re: How to pass xml type parameter to stored procedure

Anonymous — Mon, 28 Apr 2014 14:47:30 GMT

Can you have a look at
http://stackoverflow.com/questions/14892692/xml-as-parameter-in-stored-procedure-sql-server
Will this help?
Thanks
Vaibhav

topic How to pass xml type parameter to stored procedure in Talend Studio

How to pass xml type parameter to stored procedure

Re: How to pass xml type parameter to stored procedure