4 Replies Latest reply on Dec 16, 2013 2:09 PM by Matze1969

    How to store XML fragments in a XMLTYPE column

    Matze1969

      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

      Matthias