Expressions of type OBJECT, CLOB, BLOB, or XML cannot be used in comparison

[hanumath]

This is the scenario in which we are trying to consume soap web service by using of existing WSDL and exposing it again it as web service. So when we are trying to model/ create web service out of <<Filename>>.xml in “Views” Folder (Refer screen shots attached). As a result we will get Input, output xsd’s and relevant <<Filename>>WS. xmi  in “web_services” Folder.

           In <<Filename>>WS. Xmi we are getting below error at ‘Operation’ level.

ERROR: Expressions of type OBJECT, CLOB, BLOB, or XML cannot be used in comparison: CustomerOrderListServiceView_Output_View.Result_Output1View.Result_Output1.Result_Output1_Instance.xml_in = convert(VARIABLES.IN_XML_IN, xml).

So please give me any solution do you have for this.

[shawkins]

There are a couple of consderations here.  The first is that xpathvalue returns xml text values, not the full xml. So unless your xml_in is encoded as character data xpathvalue will not give you what you want.  See the XMLQUERY function instead.

The next issue of using xml in a comparison could be addressed by passing the value as a string (assuming that it is a small value).  Otherwise I'd have to know more about how the value will be used to make other suggestions.

Steve

[shawkins]

Continued at https://issues.jboss.org/browse/TEIIDDES-1818