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]( Could you please help us on this? Thanks, Senthil.
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](, you should do this in the Edit -> Output tab of the derived view dv_view1 mentioned in the [community question]( For more information about creating derived views in the Virtual DataPort Administration Tool please see the section [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