DevOps, CI/CD and Automation

need a help for the both issues, please!

I have to export every night a next day TV station EPG file (on-screen guide to scheduled broadcast television programs, allowing a viewer to navigate, select, and discover content by time, title,
channel, genre, etc, by use of their remote control) as xml file using UTF-8 <?xml version="1.0" encoding="UTF-8"?> and to copy it to the client's FTP server. so he can display it on the Web site.

Using an XML DB Oracle guide, I have managed to create a CLOB result using XML functions, but now I don't know how to proceed. Thought DBMS_XMLDOM will do the job, but I have no idea how to approach.

Any help will be more than appreciate.

Thanks in advance