ORA-03115: | unsupported network datatype or representation |
Cause: | A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection. |
Action: | Upgrade the older version of Oracle and try again. |
jdbcTemplate.execute(
sql,
new CallableStatementCallback() {
public Object doInCallableStatement(CallableStatement cs)
throws SQLException, DataAccessException {
ResultSet rs = null;
try {
rs = cs.executeQuery(sqlSelectPosnFlatAndUnsettled); ResultSetExtractor extractor
= new RowMapperResultSetExtractor(new UnsettledIndAmtDataRowMapper());
return extractor.extractData(rs);
}
finally {
JdbcUtils.closeResultSet(rs);
}
}
}
change to:
simpleJdbcTemplate.query(
sqlSelectPosnFlatAndUnsettled,
new UnsettledIndAmtDataRowMapper(),
ptrsId
);