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!

Insert Encoding tag into xml file. <?xml version="1.0"?>

858716Jun 1 2011 — edited Jun 2 2011

I am using oracle 10g.

I am using dbms_xmlgen.getxml function to generate xml data for oracle tables. I use utl_file to write data back into xml file.

Oracle is generating the file in the following manner...

<?xml version="1.0"?>
<ROWSET>
<ROW>
<RSLT_ID>1</RSLT_ID>
</ROW>
</ROWSET>

I want to change the following xml header to have encoding information in it as follows...

<?xml version="1.0" encoding = "AL32UTF8"?>

How do I achieve that?

Any suggestions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2011

Added on Jun 1 2011

2 comments

927 views