Oracle SQL - Extracting clob value from XML with repeating nodes

[lunghater]

I am attempting to run SQL on a table (called \[code\]test_xml\[/code\] with a column \[code\]xml_data\[/code\] [data type xmltype]). The column contains xml with repeating nodes (\[code\]test_3\[/code\]). The following statement runs successfully when the node contains data of a non clob size:\[code\]SELECT extractvalue (Value (wl), '*/test_3') FROM test_xml , TABLE (xmlsequence (extract (xml_data, '*/record'))) wl\[/code\]but fails when test_3 node contains a lot of data:\[quote\] ORA-01706: user function result value was too large\[/quote\]I amended my query:\[code\]SELECT extractvalue(Value (wl), '*/test_3').getClobVal() FROM test_xml , TABLE (xmlsequence (extract (xml_data, '*/record'))) wl\[/code\]but this fails with:\[quote\] ORA-22806: not an object or REF\[/quote\]