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
