Home » Developer & Programmer » JDeveloper, Java & XML » Select entire XML message from CLOB - ORA-22806 (Oracle 11gR2 )
Select entire XML message from CLOB - ORA-22806 [message #588078] Thu, 20 June 2013 12:59 Go to next message
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.
Re: Select entire XML message from CLOB - ORA-22806 [message #588079 is a reply to message #588078] Thu, 20 June 2013 13:05 Go to previous message
Barbara Boehmer
Messages: 8990
Registered: November 2002
Location: California, USA
Senior Member
You are doing things backwards. Getclobval is for converting xml to clob. To convert clob to xml, you need xmltype.
Previous Topic: Adding boilerplate into an XML template
Next Topic: Scroll table to selected Row
Goto Forum:

Current Time: Sat Apr 01 23:54:45 CDT 2023