SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to change the set of characters in a XML field

cacodriSep 28 2015 — edited Sep 28 2015

Hello everyone.

I have a table with an XML field, the table must be copied to a new one, when I run:

insert into new_table

select * from old_table;

Delivery the following error:

SQL Error: ORA-64464: Error Event XML

ORA-19202: There was an error in processing

LSX-00234: invalid decimal "4,225714285714286"

XML

00000 64464. - "XML event error"

Can someone please help me, I need to convert the character set to 'UTF8' which would solve the problem.

Thank you very much

Carlos

This post has been answered by odie_63 on Sep 28 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2015

Added on Sep 28 2015

2 comments

432 views