Returning raw XML string from Oracle XDB within Groovy / Grails
Here’s a quick solution for trying to extract the raw xml string from an Oracle XDB database when working with Grails. After an initial attempt to hardcode a hibernate query to return the raw sql using .getStringVal() as follows: SELECT x.id, x.xmlData xmldata.getStringVal(), lines.* FROM xml_requests x XMLTable(‘declare default element namespace “http://www.foo.com/fooservice”; for $i in [...]