Select entire XML message from CLOB - ORA-22806 [message #588078] |
Thu, 20 June 2013 12:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/7f8e50f422d5edddef96a908f0676dc2?s=64&d=mm&r=g) |
MarkL
Messages: 1 Registered: June 2013 Location: San Francisco
|
Junior Member |
|
|
I have a "simple" query that needs to extract all of the XML messages stored in a CLOB column in a table for a data deidentification project. This query
select c.cc_data_area.getClobVal() as cc_xml
from ci_cc c;
This query returns an ORA-22806: not an object or REF
cc_data_area is the clob column, and contains messages longer than 4000 characters.
|
|
|
|