4 Replies Latest reply: Dec 16, 2013 8:09 AM by Matze1969 RSS

    How to store XML fragments in a XMLTYPE column


      Hi all,


      maybe just another newbie question.


      I've imported a lot of xml documents into an Oracle table with a xmltype column (stored as CLOB). Now I try to select a specific part of these documents and store thsi xml fragment in another table, also in a xmltype column.


      Unfortunately this doesn't work, I get ORA-19010: Cannot insert XML fragments.


      What can I do to store part of a xml document?


      Best regards