OraFAQ Forum: JDeveloper, Java & XML » Select entire XML message from CLOB

Home » Developer & Programmer » JDeveloper, Java & XML » Select entire XML message from CLOB - ORA-22806 (Oracle 11gR2 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Select entire XML message from CLOB - ORA-22806 [message #588078]

Thu, 20 June 2013 12:59

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.

Report message to a moderator