Read XML Values from CLOB Column
Hi all,
<characteristics><characteristic id="1"><value>1957</value></characteristic>
<characteristic id="2"><value>1739</value></characteristic>
<characteristic id="4"><value>1724</value></characteristic>
<characteristic id="3"><value>1853</value></characteristic>
</characteristics> SELECT y, EXTRACT(X, '/characteristics/characteristic') FROM TABLE_Z;
i can't read the content of an clob-column.... i receive an ora-00932 with invalide datatypes.
column X is defined as CLOB:
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?><characteristics><characteristic id="1"><value>1957</value></characteristic>
<characteristic id="2"><value>1739</value></characteristic>
<characteristic id="4"><value>1724</value></characteristic>
<characteristic id="3"><value>1853</value></characteristic>
</characteristics> SELECT y, EXTRACT(X, '/characteristics/characteristic') FROM TABLE_Z;
Oracle 11.1.0.7.0
Best regards
Daniel
0