DevOps, CI/CD and Automation

We are creating an xml file using:

vc_string_clob := dbms_xmlgen.getxml('select * from mytable');
..
then opening the file with UTL_FILE.FOPEN('dir','filename','W',31767)

then parsing through vc_string_clob and using UTL_FILE.PUT_LINE to write to the file.

This all works fine, expect the header of the XML file is <?xml version="1.0"?> and our users need it to be <?xml version="1.0" encoding="ISO-8859-1"?>

Is there a function within dbms_xmlgen that will allow me to change this?

I'm thinking I can use brute force to change it, but I'm sure there is a 'more correct' way to go about it.

Thank you,
Jill Jacomine