We have a table which has a column of type 'Long'. This column stores xml which in turn contains tags with different values. We have a requirement to read few of these tags of the xml. I tried running the following query but it gave error as below-
SELECT
EXTRACTVALUE( XMLTYPE (to_lob(long_col_name)), '/xmlnodename')
FROM table_name;
Error: ORA-00932: inconsistent datatypes: expected - got LONG
Please advise and suggest alternative if any.