ORA-31167: XML nodes over 64K in size cannot be inserted

Hi

I have a table with a XmlType-column with CLOB storage.

I can insert and read xml-data containing base64 encoded JPEGs with OCILob functions. The image data contains > 64K.

The problem: a query like 'select extract(xmldata, '/img/@name') ...' executed in sqlplus or SqlDeveloper gives the error

ORA-31167: XML nodes over 64K in size cannot be inserted Cause: An attempt was made to insert an XML Text Node with a size greater than 64K. This is not supported. Action: Create text nodes under 64K.

But the data is already in the db. I only want to read some piece ( ~20 byte ) of it.
Where is the problem?

The problem exists in 10.2.0.1 and 10.2.0.2 on Windows.

Lars Received on Thu Jul 20 2006 - 05:43:26 CDT