Subject:XQuery external variable conversion failure since upgrade to SS 2008 Author:Thais Flory Date:30 May 2008 04:51 PM
I have an XQuery node in an XML Pipeline, which has this prolog:
declare variable $ck as xs:integer external;
A default value of 21 is assigned to the node's input port "ck" and I get this error:
Error: XQUERY processing by XQUERY node 'Web 2 DB to XML Map' failed: Error encountered while initializing variable ck with value xs:integer('21'):
[DataDirect][XQuery]The value "xs:integer('21')" cannot be converted to the XQuery data type xs:integer.
I test the same project with SS 2007 and it works fine. Please let me know what changed or if this is just a bug that needs fixed.