<?xml version="1.0" encoding="UTF-8" ?>
- <ns:AccountQueryPage_Output xmlns:ns="urn:crmondemand/ws/ecbs/account/">
- <ListOfAccount xmlns="urn:/crmondemand/xml/Account/Data" lastpage="true">
- <Account>
  <Id>CCC-TEST01</Id>
  <AccountName>John Smith Pty Ltd</AccountName>
  </Account>
  </ListOfAccount>
  </ns:AccountQueryPage_Output>

import groovy.sql.Sql

String fileContents = new File('C:\Documents\test.xml').getText('UTF-8')
println fileContents

sql = Sql.newInstance("jdbc:oracle:thin:@localhpst:1521/orcl.com", "SCOTT", "Password","oracle.jdbc.pool.OracleDataSource")
sql.execute("""INSERT INTO SCOTT.RESP VALUES(fileContents)""")