<?xml version="1.0" encoding="UTF-8"?>
<Request>
<EquipmentId>9134862155013443</EquipmentId>
<EquipmentType></EquipmentType>
<EquipmentName>E#117</EquipmentName>
</Request>

List<String> result = new JdbcTemplate(dataSource).queryForList(QUERY, String.class);
System.out.println(result.toString());

List ["9134862155013443E#117"]

<?xml version="1.0" encoding="UTF-8"?>
<Request>
<EquipmentId>9134862155013443</EquipmentId>
<EquipmentType></EquipmentType>
<EquipmentName>E#117</EquipmentName>
</Request>

List ["9134862155013443E#117"]

SELECT *
FROM dba_tab_columns
WHERE table_name = 'Name'
and column_name = 'MESSAGE';

<?xml version="1.0" encoding="UTF-8"?><Request><EquipmentId>9134862155013443</EquipmentId><EquipmentType></EquipmentType><EquipmentName>E#117</EquipmentName></Request>

9134862155013443E#117

CREATE TABLE CUSTOMER_TBL (
NAME VARCHAR2(100),
MESSAGE VARCHAR2(4000));

Select MESSAGE  from osa_message_storage;

List<String> result = new JdbcTemplate(dataSource).queryForList(QUERY, String.class);

Select MESSAGE  from CUSTOMER_TBL;

<?xml version="1.0" encoding="UTF-8"?><Request><EquipmentId>9134862155013443</EquipmentId><EquipmentType></EquipmentType><EquipmentName>E#117</EquipmentName></Request>

BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("oracle.jdbc.driver.OracleDriver");
        dataSource.setUrl("jdbc:oracle:thin:@" + DB_SERVER + ":" + DB_PORT + ":" + DB_SID);
        dataSource.setUsername(DB_USER);
        dataSource.setPassword(DB_PASSWORD);
        dataSource.setMaxActive(10);
        dataSource.setAccessToUnderlyingConnectionAllowed(true);
List<String> result = new JdbcTemplate(dataSource).queryForList("Select MESSAGE  from CUSTOMER_TBL", String.class);
System.out.println(result.toString());

List<String> result = new JdbcTemplate(dataSource).queryForList("select dbms_xmlgen.getXml('select * from DUAL') from DUAL", String.class);

^-- error here -- ORA-00911: invalid character 

List<String> result = new JdbcTemplate(dataSource).queryForList(
  "select \n" +
  "'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" +
  "<Request>\n" +
  "<EquipmentId>9134862155013443</EquipmentId>\n" +
  "<EquipmentType></EquipmentType>\n" +
  "<EquipmentName>E#117</EquipmentName>\n" +
  "</Request>'\n" +
  "from DUAL", String.class
);

 9134862155013443 E#117