If anyone runs into this same issue, here is what i found. XML
datatype can not be used currently in an output param of a sproc.
This is from the Using Advanced Data Types section of:
http://msdn2.microsoft.com/en-US/library/ms378813.aspx
Note the last paragraph.
XML Data Type
SQL Server 2005
I have a stored proc that is returning a sql 2005 xml datatype. The
sql server docs say to use LONGVARCHAR as the data type but I am
getting the same error whether I call the proc from a java class or a
coldfusion page.
Implicit conversion from data type xml to varchar is not allowed.
Anyone
2 matches
Mail list logo
