[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1818) Expressions of type OBJECT, CLOB, BLOB, or XML cannot be used in comparison
[
https://issues.jboss.org/browse/TEIIDDES-1818?page=com.atlassian.jira.plu...
]
Steven Hawkins updated TEIIDDES-1818:
-------------------------------------
Forum Reference: https://community.jboss.org/thread/231033
The heart of the issue is that we are overloading the meaning of a comparison predicate to
also seem like a parameter assignment (there is similar behavior to procedural relational
queries). This was a legacy design choice that is not well suited for null values, lobs,
determining default values, etc.
It's not clear from your model, but if Result_Output1_Instance is a procedure, then
you need to call it as a procedure:
CALL Result_Output1_Instance(xml_in=>xml_var);
Otherwise as mentioned in the forum post, the simplest workaround is to use a string type
to pass the value instead. If the value is too large, then it is possible to use a clob,
but you also have to enable comparable lobs -
https://docs.jboss.org/author/display/TEIID/System+Properties
Depending upon your usage though (which again is not clear from just the screenshots) is
that the xml document model logic does not have the concept of including fragments of
other xml in the xml output. That would currently require custom sql/xml.
Expressions of type OBJECT, CLOB, BLOB, or XML cannot be used in
comparison
---------------------------------------------------------------------------
Key: TEIIDDES-1818
URL: https://issues.jboss.org/browse/TEIIDDES-1818
Project: Teiid Designer
Issue Type: Feature Request
Components: Modeling, Web Services Support
Affects Versions: 8.1
Environment: OS - Windows7, JBoss Studio6.0, EAP server 6.1, Teiid Designer 8.1
Final and Teiid Server 8.4 Final
Reporter: Hanumath Aalapati
Attachments: DataTypeError.jpg
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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira