Error converting XML from CLOB column to XMLType column

Question

I am trying to convert some XML data coming from a CLOB to an XMLType column.

XML has some underlined characters as meanings (documents are written in French).

Here is what the instruction looks like:

insert into mytable (id, xmldata) values (p_id, xmltype(p_xmldata));

p_idand p_xmldataare variables previously extracted from the source table.

I think that French characters do not allow XMLType to work correctly. Or maybe the wrong XML tags? The problem is that the table contains 3k + XML documents and only 2 are converted to an XMLType column.

---

Update: These are the errors that I get when I try to make simple:

select xmltype(xmldata) from mytable

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.XMLTYPE", line 254
ORA-06512: at line 1

Answer 1

createxml,

insert into mytable (id, xmldata) values (p_id, xmltype.createxml(p_xmldata));