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 provides an XML data type that lets you store XML documents and fragments in a SQL Server database. The XML data type is a built-in data type in SQL Server, and is in some ways similar to other built-in types, such as int and varchar. As with other built-in types, you can use the XML data type as a column type when you create a table; as a variable type, a parameter type, or a function-return type; or in Transact-SQL CAST and CONVERT functions. In the JDBC driver, the XML data type can be mapped as a string, byte array, stream, CLOB, or BLOB object. String is the default representation. The implementation of the XML data type in the JDBC driver provides the following: Supports access to the XML as a standard Java UTF-16 string for most common programming scenarios Supports input of UTF-8 and other 8-bit encoded XML Supports access to the XML as a byte array with a leading BOM when encoded in UTF-16 for interchange with other XML processors and disk files SQL Server requires a leading BOM for UTF-16-encoded XML. The application must provide this when XML parameter values are supplied as byte arrays. SQL Server always outputs XML values as UTF-16 strings with no BOM or embedded encoding declaration. When XML values are retrieved as byte[], BinaryStream or Blob, a UTF-16 BOM is pre-pended to the value. Note: The JDBC driver does not support reading stored procedure output parameters of the XML data type. However, it does support using the XML data type as input parameters. If you have to use the XML data type as an output parameter, you must first convert the XML data type to a VARCHAR or LONGVARCHAR in the stored procedure before it can be read. For more information about the XML data type, see "xml Data Type" in SQL Server Books Online. Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241436 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
