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!

Non Printable characters using dbms_xmlgen

858716Jun 13 2011 — edited Jun 13 2011

Hi,
Currently I am passing sql query of select * from table to this oracle API returning XML data into a clob and then use utl_file package to write it back into flat file.

I have a column in DB which upon certain error loads a value which has non printable character in it. Its not viewable directly on sqlplus so I ran the query to find its ascii() value and it turned out to be ASCII 4 which is EOT [End of transmission]

dbms_xmlgen.getxml is is not able to handle it and generate xml file from this table. Its throwing ORA- 31011

ORA-31011: XML parsing failed

Is it possible to still use this Oracle API[dbms_xmlgen] and generate XML file while table contains the ASCII characters as described above?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2011

Added on Jun 13 2011

5 comments

1,140 views