Skip to Main Content

Oracle Database Discussions

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!

DBMS_XMLGEN.CONVERT fail with clobs only

OU_230May 1 2024

I am using Oracle database 19.4 standard edition
This works
select DBMS_XMLGEN.CONVERT((chr(2)) ) from dual;

but when converting to clob it fails

select DBMS_XMLGEN.CONVERT(to_clob(chr(2)) ) from dual
ORA-64451: Conversion of special character to escaped character failed.
ORA-06512: at "SYS.DBMS_XMLGEN", line 29
ORA-06512: at "SYS.DBMS_XMLGEN", line 301
ORA-06512: at line 1

Why is this the case?

Comments
Post Details
Added on May 1 2024
1 comment
395 views