Error when converting XML from a CLOB column to XMLType column

Question

I'm trying to convert some XML data coming from a CLOB to a XMLType column.

The XML have some accentuated characters as values (documents are written in french).

Here is what the instruction looks like :

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

p_id and p_xmldata are variables previously extracted from the original table.

I think the french characters prevents XMLType to work correctly. Or maybe malformed XML tags? The problem is, the table holds 3k+ XML documents and only 2 are converted in the XMLType column.

Update: These are the errors I get when I try a 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

Philippe · Accepted Answer · 2009-08-03 20:20:39Z

7

I used createxml method and now it works fine

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

edited Aug 3, 2009 at 20:20

answered Aug 2, 2009 at 22:18

Philippe

1,8431 gold badge17 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rohan Over a year ago

Thanks a lot man. This minor change proved hugely beneficial for me.

Collectives™ on Stack Overflow

Error when converting XML from a CLOB column to XMLType column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related