Forum Stats

  • 3,741,445 Users
  • 2,248,430 Discussions
  • 7,861,812 Comments

Discussions

Reading XML from Long Datatype

2677588
2677588 Member Posts: 1
edited May 21, 2014 7:40AM in SQL & PL/SQL

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.

Tagged:

Answers

This discussion has been closed.