You can translate the question and the replies:

Issue type casting BLOB to XML Data Columns

Hi , I am trying to extract the XML data from Blob column in oracle database. I was refreing the below solution to convert blob to XML data. but still I am getting the error. ‘cast($1 as $0) -> Cast to xml not supported in Oracle’. [XML Data in BLOB into Columns](https://community.denodo.com/answers/question/details?questionId=9060g000000XdR7AAK&title=XML+Data+in+BLOB+into+Columns) Could you please help us on this? Thanks, Senthil.
user
27-09-2018 14:14:03 -0400

1 Answer

Hi, When I try to cast a BLOB/CLOB field in Denodo from Oracle, I get the expected result in my column. Please note that when you apply the [CAST](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/type_conversion_functions#cast), you should do this in the Edit -> Output tab of the derived view dv_view1 mentioned in the [community question](https://community.denodo.com/answers/question/details?questionId=9060g000000XdR7AAK&title=XML+Data+in+BLOB+into+Columns). For more information about creating derived views in the Virtual DataPort Administration Tool please see the section [Creating Selection Views](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views) in the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
01-10-2018 10:45:55 -0400
You must sign in to add an answer. If you do not have an account, you can register here