DSXchange

I just wanted to ensure you saw his entire response. The way I read it, the 'writing to a file' part was just to ensure the XML in the CLOB was well formed. Once that was confirmed, switch back to sourcing directly from the table but use the "content" option rather than the URL to read the data into the stage. Plus what he noted about delimiters and quotes.

Yes....debugging techniques, everyone! Take things one step at a time!

Don't try to put everything together at once --- and that goes for whatever you are building, not just xml, rdbms, and clobs.

Ernie