a4apple thanks for the link.

I needed to add select (...) as COL_XML that did the trick.

Thanks everyone for your help.